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)

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




This discussion has been closed.