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,


Toni

Best Answer

  • =Chris Palmer
    =Chris Palmer ✭✭✭✭✭
    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"

    https://www.linkedin.com/in/zchrispalmer/

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!