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
-
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"
Answers
-
Hi @ToniC44
For the Gray, are you specifically looking for the words including the brackets: "[On Hold]"
-
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"
-
Removed the brackets and all is working now :) Thank you!
-
Excellent! Happy this worked :-)
Help Article Resources
Categories
Check out the Formula Handbook template!