Formula to identify current approver
I have a worksheet with a multi-approver workflow on it. Upper Management wants a report that shows who is the current approver without having to see all of the previous approvers.
Does anyone know, is there a way to construct a formula that would identify which approver the request currently resides with?
The structure of the sheet is something like this: https://app.smartsheet.com/b/publish?EQBCT=a28a7318e8d543d99dd7f8332a48662d
Any and all thoughts are welcome. Thank you for the help.
Help Article Resources
Check out the Formula Handbook template!