IF function question

Options

How would I write an if statement for a symbol column based on what I have in a stage column? Ex. IF Stage column says Complete= blue, If On Hold = red, If any of these: Not Started, Pre-Install QC Survey, Pending Install IH, Pending Install BP, Post-Install QC, Follow-up =green, to show in the Status (symbol) column?

Best Answer

  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭
    Answer ✓
    Options

    Try this: =IF(ISBLANK([Stage Column]@row), "", IF([Stage Column]@row = "Complete", "Blue", IF([Stage Column]@row = "On Hold", "Red", "Green")))

    You didn't have a rule for Yellow so I've left that out and I added in if Status is blank, but you can take that out if you don't need it.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!