Yellow RAG Formula: Between 2 Numbers (Greater Than Less Than)
Greetings Smartsheet Community:
I Need to Add a Range in my Formula Between -9 & -1 to Turn Yellow. Thanks
Current Formula:
=IF(OR([Schedule Variance]@row > 0, [Schedule Variance]@row = 0), "Green", IF([Schedule Variance]@row <= -10, "Red"))
Best Answers
-
Try this. I would usually put the checks for ISBLANK first in the nested IF, then check the conditions for the Schedule Variance. The logic in IF statements can be a little weird and take some practice. I'd suggest reading up on the IF function in their online help.
You have to be careful with placement of the parenthesis for both the IF statement and any other functions like ISBLANK that you're using.
=IF(ISBLANK([Schedule Variance]@row), "Gray", IF([Schedule Variance]@row >= 0, "Green", IF([Schedule Variance]@row <= -10, "Red", "Yellow")))
-
Excellent, That Worked! Thanks
Answers
-
=IF([Schedule Variance]@row >= 0, "Green", IF([Schedule Variance]@row <= -10, "Red", “Yellow”))
-
That Worked, but I forgot to Add If Schedule Variance is Blank / Empty, then the Result Should be Gray.
My Attempt but Unsuccessful:
=IF([Schedule Variance]@row >= 0, "Green", IF([Schedule Variance]@row <= -10, "Red", "Yellow", IF(ISBLANK([Schedule Variance]@row, "Gray"))))
-
Try this. I would usually put the checks for ISBLANK first in the nested IF, then check the conditions for the Schedule Variance. The logic in IF statements can be a little weird and take some practice. I'd suggest reading up on the IF function in their online help.
You have to be careful with placement of the parenthesis for both the IF statement and any other functions like ISBLANK that you're using.
=IF(ISBLANK([Schedule Variance]@row), "Gray", IF([Schedule Variance]@row >= 0, "Green", IF([Schedule Variance]@row <= -10, "Red", "Yellow")))
-
Excellent, That Worked! Thanks
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
