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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!