#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Automate RYG (percentages)

edited 12/09/19

Hi everyone, probably more of the same, but I cannot make my formula work... what I want is to change the color according to percentages in a different column, 0%to 33% Red, 34%to66%Yellow and 67% to 100% turn to green.

I have used this formula, but is not working, any other thoughts around this?

=IF([% Complete]1<=33,"Red",IF(AND([% Complete]1>33,[% Complete]1<=66)=TRUE,"Yellow","Green"))

Thanks

• ✭✭✭✭✭✭

When numbers are formatted as percentages, then you need to reference them as portions of 1. Try this: =IF([% Complete]1<=.33,"Red",IF(AND([% Complete]1>.33,[% Complete]1<=.66)=TRUE,"Yellow","Green"))

See if that works. 1=100%.

• Hi Mike, thanks for your answer, but still, this is not working... I've used your formula,  but I'm getting the same results: #UNPARSEABLE...

• ✭✭✭✭✭✭

Doh..  I didn't notice some extra text you had in there. I removed the =True part. Try this...

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

• Yeah!!! That's it, now is working, thanks for your help Mike... brilliant!

• ✭✭✭✭✭✭