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!

Tags:
· Share on FacebookShare on Twitter

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    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(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)))

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!