# Trouble with RYG Formula:

edited 12/09/19

Can anyone tell me what I am doing wrong here?  I am trying to automate RYG balls from a % column.

=IF([% Complete]3 < 50, "Red", IF([% Comlete]3 = 100, "Green, IF([% Complete] >50 AND <100, "Yellow")

Tags:

• =IF([% Complete]3 < 50, "Red", IF([% Complete]3 = 100, "Green, IF([% Complete] >50 AND <100, "Yellow")

Corrected spelling error!

• ✭✭✭✭✭✭

Smart sheet displays the percentages as such, but in reality the backend is reading a decimal. When referencing perecentages in formulas you should use .5 for 50% and 1 for 100%. SO your formula would look like this...

=IF([% Complete]3 < .5, "Red", IF([% Complete]3 = 1, "Green, IF([% Complete] >.5 AND <1, "Yellow")

• Thanks Mike, but there is still something wrong:  unparseable!

I have tried a dozen times with the same results!

• ✭✭✭✭✭✭

Duh I should have looked more carefully!  And statements should be made as indicated below...

=IF([% Complete]3 < .5, "Red", IF([% Complete]3 = 1, "Green, IF(AND([% Complete]3 >.5, [% Complete]3 <1), "Yellow")))

You also didn't have enough closing parenthesis.

• Maybe I have been staring at this too long!  It still doesn't work.  Did it work for you?

YOU are a peach, by the way.  Thanks for helping.

• ✭✭✭✭✭✭

Are you getting unparseable still?

• ✭✭✭✭✭✭

=IF([% Complete]3 < .5, "Red", IF([% Complete]3 = 1, "Green", IF(AND([% Complete]3 >.5, [% Complete]3 <1), "Yellow")))

Green was missing a closing quotation mark!

• Yes

#baldfromtearinghairout

• ✭✭✭✭✭✭

Did this one work?

=IF([% Complete]3 < .5, "Red", IF([% Complete]3 = 1, "Green", IF(AND([% Complete]3 >.5, [% Complete]3 <1), "Yellow")))

Green was missing a quotation mark!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!