Health formula help

Hi all,

Can anyone tell me what is wrong with my formula:

=IF(Status@row = "Complete", "Green", IF(Status@row = "[On Hold]", "Gray", IF(Finish@row <> "", IF(Finish@row < TODAY(), "Red", IF(Finish@row <= TODAY(5), "Yellow", IF(Finish@row >= TODAY(1), "Green"))))))

All is working aside from the gray ball if on hold is not showing, and no error message- probably something glaringly obvious but I just cant seem to figure it out.

Many thanks,


Best Answer

  • Mr. Chris
    Mr. Chris ✭✭✭✭✭
    edited 05/18/23 Answer ✓

    Hello @Toni,

    Just curious, are the brackets really necessary within "[On Hold]" ?

    I'm curious if you've tried "On Hold".

    Additionally, if there are different variations of "On Hold" you could try:

    IF(CONTAINS("On Hold", Status@row), "Gray"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!