Nested If Statement Not Working

I am trying to write a nested IF statement to automate the RYG status balls in a status column.

It will not work, it always say they are red. What am I doing wrong?

Logic Needed:

If less than 70% complete, "Red" status ball

If 70% or above and less than 100% complete, "Yellow" status ball

If 100% complete, "Green" status ball

Formulas I have tried:

=IF([% Complete]@row < 70, "Red", IF([% Complete]@row = 100, "Green", "Yellow"),"Yellow")

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




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!