RYG formula for indicating expense vs. budget

Options

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!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!