Health Status Formula
Hi!
Currently, I have a formula in place to indicate R,Y,G Health based on the Start/Due Date. Is it possible to add an =OR function so that if "Status" column is switched to complete the Health will indicate green.
Sorry .. very new to this.
Best Answer
-
You are missing the 2nd "If" in bold:
=If(Status@row="Complete", "Green", IF([Due
Answers
-
Adding an additional IF statement to the beginning of your formula should work.
You will also need to add an additional closing parenthesis at the end of the formula.
IF(Status@row = "Complete", "Green", + existing formula + additional )
Hope this helps!
-
Thanks for your reply! Is this the way it should be written? If so I get a unparseable error. Thoughts?
-
You are missing the 2nd "If" in bold:
=If(Status@row="Complete", "Green", IF([Due
-
@ker9 There it is. Thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
