RYG automation based on percentage

edited 12/09/19 in Formulas and Functions

 I am hoping to get a formula to work for me- I have read a million boards and non of them work for me!


What I am looking to do. 


If percent >=100, red circle

If percent >= 50 and <100 yellow  circle

If percent <50, green circle


this is the formula I am currently using;

=IF([Percent of budget spent]2 >= 100, "Red", IF(AND([Percent of budget spent]2 > 0, ( [Percent of budget spent]2 <50, "Yellow", "Green")))


Any help is appreciated!






Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!