IF statement to Output Column Contact List Name
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.
I'm thinking that the IF statement may not be the best when trying to reference a cell contact.
Appreciate any help with this =).