Multi-level approval notification challenge

edited 12/09/19 in Smartsheet Basics

Hi There,

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?