Why isn't the email address pulling via formula from another sheet for "contact"?

Amber Lange

I created a Form for operations to fill out when they determine a ship date needs to push out. Since they don't always know who the Project Manager is, I have this information going into a sheet where the project number pulls the PM info from a master project list using the COLLECT formula. But when I try to create the automation to send a notification to the PM that pulls in the column set as CONTACT LIST, it's only the name, not the email address, so nothing happens. Thoughts?

Paul Newcome

Glad you were able to get it sorted. 👍️

Paul Newcome

What is the actual formula you are using?

Amber Lange

Paul - I think I figured it out by using a VLOOKUP. I tested it and it seems to work fine. I was overcomplicating my process! :)

Paul Newcome

Glad you were able to get it sorted. 👍️