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?
Tags:
Best Answer
Answers
-
-
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! :)
-
