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
Check out the Formula Handbook template!