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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!