IF statement to Output Column Contact List Name

edited 04/23/21 in Formulas and Functions
04/23/21 Edited 04/23/21
Accepted

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([email protected] = [Phase 1]@row, "[Phase 1 Contact]@row", IF([email protected] = [Phase 2]@row, "=[Phase 2 Contact]@row", IF([email protected] = [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!

Best Answer

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    Accepted Answer

    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([email protected] = [Phase 1]@row, [Phase 1 Contact]@row, IF([email protected] = [Phase 2]@row, [Phase 2 Contact]@row, IF([email protected] = [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([email protected] = "Phase 1", [Phase 1 Contact]@row, IF([email protected] = "Phase 2", [Phase 2 Contact]@row, IF([email protected] = "Phase 3", [Phase 3 Contact]@row)))

    thinkspi.com

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    Accepted Answer

    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([email protected] = [Phase 1]@row, [Phase 1 Contact]@row, IF([email protected] = [Phase 2]@row, [Phase 2 Contact]@row, IF([email protected] = [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([email protected] = "Phase 1", [Phase 1 Contact]@row, IF([email protected] = "Phase 2", [Phase 2 Contact]@row, IF([email protected] = "Phase 3", [Phase 3 Contact]@row)))

    thinkspi.com

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

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help. 👍️

    thinkspi.com

Sign In or Register to comment.