# RYG automation based on percentage

Options
edited 12/09/19

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!

• ✭✭✭✭✭✭
Options

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

• Options

That came up as #UNPARSEABLE, any other ideas?

• ✭✭✭✭✭✭
Options

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

• Options

now it is saying #incorrect argument

• Options

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!