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

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?

Find more posts tagged with

Forms

Automations

Accepted answers

Paul Newcome

Glad you were able to get it sorted. 👍️

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.