I need help with this formula. I can't seem to get the formula right

I've been having issue coming up with nested-if formula for this.

Use a nested-if formula to automate the RYG status balls in the "Status "column, depending on the "% Complete" for each request.


If a request is less than 70% complete, turn the "Status" column into a "Red"

If a request is 70% or above and less than 100% complete, turn the "Status" column into a "Yellow"

If a request is 100% complete, turn the "Status" column into a "Green"

Best Answer

  • ker9
    ker9 ✭✭✭✭✭✭
    Answer ✓

    Hi @Von Gossi

    Please try this in your status column (presuming you have % formatted in the % Complete column):

    =IF([% Complete]@row = 1, "Green", IF([% Complete]@row > 0.69, "Yellow", "Red"))

    Hope this helps!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!