Nested IF/AND Formula

I'm trying to get a formula that performs the following for status.

Criteria is:

Less than 75% complete=Red

Between 71%-100%=Yellow

100% Complete=Green

This is what I have built but keep getting the "Incorrect Argument Set" posting.

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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!