Hello!
I feel like this is a fairly easy formula, but having issues populating the ACTUAL contact name vs. the TEXT value using an IF statement.
Goal: In this example, when I change the status to phase 1, I would like the Current Assignee cell to populate the contact name. However it is populating the value and not the actual contact.
=IF(Status@row = [Phase 1]@row, "[Phase 1 Contact]@row", IF(Status@row = [Phase 2]@row, "=[Phase 2 Contact]@row", IF(Status@row = [Phase 3]@row, "=[Phase 3 Contact]@row")))
I'm thinking that the IF statement may not be the best when trying to reference a cell contact.
Appreciate any help with this =).
Thank you!