Journal Approval (spreadsheet) - does it support lookup ?
Would like to know if I can use lookup as one of the approval rule logic
Our client is looking to implement journal approval rule in 23B. So using spreadsheet.
I need to create a rule which specifies who approvers are based on journal submitter. Obvious choice is to specify username in spreadsheet.
However I see it is not convenient as the username seem to be case sensitive and the client needs to update the rule every time there is a movement.
Is there an option to use a list similar to Approval Group ? Perhaps Lookup ?
So the rule looks like