Help With Formula

I really struggle with formulas. I am trying to create a nested if formula to automate RYG in a status column. So I need to show the following.

If % complete is less than 70% turn the status red, if it's 70% or more turn status yellow, if it's 100% complete turn status green. This is what I have, any help would be greatly appreciated. Hopefully this isn't too far off, like I said, I struggle with these. Thanks!


=IF([%Complete]@row<.7,"Red", IF([%Complete]@row >.7, "Yellow"', IF([%Complete]@row= 1, "Green"))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!