If Formula with Contact in Contact Column

Trying to build a formula that if X person is entered into "Project Manager" column, their corresponding team email contact will populate in the "Team Email" contact column. Both are contact columns.

Here is what I have so far, I've tried with and without quotations:

=IF([Project Manager]@row = Abby, Team 1, IF([Project Manager]@row = Rose, Team 2))

Appreciate any and all help!

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try using quotes around the text strings:

=IF([Project Manager]@row = "Abby", "Team 1", IF([Project Manager]@row = "Rose", "Team 2"))

aecross

Thanks @Paul Newcome!

"Team 1" is a contact that has an email attached. How can i get this formula to show the team as a contact, not just text?

Paul Newcome

You would need to have the formula output the email address.

How many teams do you have?

aecross

4 teams total.

archteam4@archteam4.com

Paul Newcome

In that case I would stick with the nested IF, and you would need to output the email address itself.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.