I have two numbers or dates

Baseline budget 100,000

Current budget 35,000

Variance is 65,000


If I do a  % calculation (variance/baseline) then its 65%


I have a health indicator that says if the variance is > 10% then red, more than 5% and < 9% then yellow, lower then green.


However, we are WAY under budget in this example so it goes red - how do I fix?


sorry I'm being dense



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!