Nested IF/AND Formula

Options
Doug L.
Doug L. ✭✭
in Formulas and Functions

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"))

· Share on FacebookShare on Twitter

Best Answer

  • Doug L.
    Doug L. ✭✭
    Answer ✓
    Options

    Solved it myself!

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

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!