RYG automation based on percentage
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!
Comments
-
The primary thing you have to know about smartsheets and percentage formatted columns is that the percentages are formatted as decimals.
1=100% and .5 = 50%.
Your formula, if you are using a % formatted column should like this.
=IF([Percent of budget spent]2 >= 1, "Red", IF(AND([Percent of budget spent]2 > 0, ( [Percent of budget spent]2 <.5, "Yellow", "Green")))
-
That came up as #UNPARSEABLE, any other ideas?
-
Oh yes, there was an extra parenthesis in there. Try this one.
=IF([Percent of budget spent]2 >= 1, "Red", IF(AND([Percent of budget spent]2 > 0, [Percent of budget spent]2 <.5, "Yellow", "Green")))
-
now it is saying #incorrect argument
-
Mackies,
The formula should be the following:
=IF([Percent of budget spent]2 >= 1, "Red", IF(AND([Percent of budget spent]2 > 0, [Percent of budget spent]2 <.5), "Yellow", "Green"))
Help Article Resources
Categories
Check out the Formula Handbook template!
