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"))
Help Article Resources
Check out the Formula Handbook template!