Nested IF statements with RYB symbols

I am trying to use RYG fill symbols in a nested if statement.

if % complete is 100% = Green

if % complete is less then 70% = Red

if % complete is greater then 70% and less then 100% = Yellow

Here is what I have, and I am getting a #INCORRECT ARGUMENT

=IF([% Complete]@row = 1, "Green", IF([% Complete]@row < 0.7, "Red", IF(AND([% Complete]@row >= 0.7, [% Complete]@row < 1, "Yellow"))))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!