IF function question


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 ✓

    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!