IF statement to Output Column Contact List Name

Allen Chin

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!

Paul Newcome

Adding the quotes around the cell references means it would output EXACTLY what is between the quotes instead of what is in the cell. Try this...

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

You can also simplify your sheet a little bit by removing the "Phase" columns and just referencing specific test in the Status column. The below will allow you to get rid of the [Phase 1], [Phase 2], and [Phase 3] columns from your sheet.

=IF(Status@row = "Phase 1", [Phase 1 Contact]@row, IF(Status@row = "Phase 2", [Phase 2 Contact]@row, IF(Status@row = "Phase 3", [Phase 3 Contact]@row)))

Paul Newcome

Adding the quotes around the cell references means it would output EXACTLY what is between the quotes instead of what is in the cell. Try this...

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

You can also simplify your sheet a little bit by removing the "Phase" columns and just referencing specific test in the Status column. The below will allow you to get rid of the [Phase 1], [Phase 2], and [Phase 3] columns from your sheet.

=IF(Status@row = "Phase 1", [Phase 1 Contact]@row, IF(Status@row = "Phase 2", [Phase 2 Contact]@row, IF(Status@row = "Phase 3", [Phase 3 Contact]@row)))

Allen Chin

Oh the "quotes", thank you for taking a look at this and for getting rid of 3 additional columns!

Paul Newcome

Happy to help. 👍️