RYG automation based on percentage

Mackies

 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!

 

 

 

 

Mike Wilday

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")))

Mackies

That came up as #UNPARSEABLE, any other ideas?

 

Mike Wilday

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")))

Mackies

now it is saying #incorrect argument

friendlyhelperteam

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"))