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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!