HI! I am fairly familiar with excel but I am really having a problem with the calculations below. The Approval History is formatted as General, the Closed as Custom but no matter what I do with formatting it won't fix the error. One thing that did work is adding the text, even just the " - Group approval" part (no quotations) and it will work. I think I used to know this but I am stumped on why this is happening. Other question is, what is the purpose of the 2 hyphens in front of MID. (I think I know but I am not sure so I am asking.) Thank you so much and the quicker I can get an answer the better. I will be watching for responses.
<tbody>
</tbody>
Approval History | Closed | Function Approval Hx | Function Closed | ||
03/22/2018 08:49:02 AM - Group approval for Gatekeeper approved by user Angl Hoo (Group Approval). | 3/23/2018 12:35:04 PM |
<tbody> </tbody> |
<tbody> </tbody> | ||
IF(ISBLANK(E2),"",IF(ISERROR(--MID(E2,FIND("/",E2)-2,10)),--MID(E2,FIND("/",E2)-1,9),--MID(E2,FIND("/",E2)-2,10))) | IF(ISBLANK(E2),"",IF(ISERROR(--MID(E2,FIND("/",E2)-2,10)),--MID(E2,FIND("/",E2)-1,9),--MID(E2,FIND("/",E2)-2,10))) |
<tbody>
</tbody>