Health formula help

ToniFK · 05/18/23

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

=Chris Palmer · 05/18/23

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"

ker9 · 05/18/23

Hi @ToniC44

For the Gray, are you specifically looking for the words including the brackets: "[On Hold]"

=Chris Palmer · 05/18/23

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"

ToniFK · 05/18/23

Removed the brackets and all is working now :) Thank you!

=Chris Palmer · 05/18/23

https://community.smartsheet.com/discussion/comment/376505#Comment_376505

Excellent! Happy this worked :-)

Health formula help

Best Answer

Answers

Help Article Resources

Categories