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

Amber Lange
Amber Lange ✭✭
edited 06/15/22 in Smartsheet Basics

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?

Best Answer