If Formula with Contact in Contact Column

aecross

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!

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.

[email protected]

Paul Newcome

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