Nested if RYG
I am trying to write the easiest "if" statement and It will not work.... All I am trying to is the following:
Red if the "action due date" is in the past and the "Status 2" is either Open, In Planning, In Testing, Monitoring.
Yellow if he "action due date" is Today and the "Status 2" is either Open, In Planning, In Testing, Monitoring.
Green for everything else
Answers
-
=IF(AND(([Date 1]@row < TODAY()), (OR([Status 2]@row = "OPEN", [Status 2]@row = "In Planning", [Status 2]@row = "In Testing"))), "Red", IF(AND(([Date 1]@row = TODAY()), (OR([Status 2]@row = "OPEN", [Status 2]@row = "In Planning", [Status 2]@row = "In Testing"))), "Yellow", "Green"))
... seems to work ... (I don't think I have nested ORs inside an AND before, at least not in SmartSheet)
Btw, the colours needed to be lower case or the symbols/bubbles didn't appear.
dm
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!