Multi-level approval notification challenge
I am try to create a multi-level approval form, where I have created several columns to hold dynamic approver names (based on the submitter), based on a specific set of criteria. I then use a VLOOKUP formula to populate the text field from a contact field in a 'reference' SS containing the relationships of submitters and their approvers. Everything populates properly when a new row is inserted at the top of the SS (from a form), but I am unable to send the approval request because the "Send Approval Request to" a "Contact in Column" won't recognize the text field containing the approver name (pulled from a contact field on a different SS) as a contact field so I can't select it.
Can anyone suggest an alternate method?