RYG formula for indicating expense vs. budget
Hi,
I am trying to use RYG balls to indicate how much remains in a budget (red indicates 90% spent, Yellow indicates 75% spent) Using this formula, I get green and yellow, but I can't seem to get red, even though there are expense/budget over 90%
=IF(Charged14 / [Budget Allocated]14 > 0.75, "Yellow", IF(Charged14 / [Budget Allocated]14 < 0.75, "Green", IF(Charged14 / [Budget Allocated]14 > 0.9, "Red")))
Any tips? Is there a better way of doing this?
Thank you!
Best Answer
-
Try putting your red as the first argument. Nested IF's work from left to right and stop at the first true value. Since 91% is greater than 75%, it flags the yellow argument as true and stops.
Answers
-
Try putting your red as the first argument. Nested IF's work from left to right and stop at the first true value. Since 91% is greater than 75%, it flags the yellow argument as true and stops.
-
Paul to my rescue, again! That worked, thank you!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 382 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!