IF statement to Output Column Contact List Name

Allen Chin
Allen Chin โœญโœญ
edited 04/23/21 in Formulas and Functions

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")))

Screen Shot 2021-04-23 at 7.35.15 AM.png

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!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!