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!
Answers
-
Try using quotes around the text strings:
=IF([Project Manager]@row = "Abby", "Team 1", IF([Project Manager]@row = "Rose", "Team 2"))
-
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?
-
You would need to have the formula output the email address.
How many teams do you have?
-
4 teams total.
-
In that case I would stick with the nested IF, and you would need to output the email address itself.
Help Article Resources
Categories
Check out the Formula Handbook template!