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

Question

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"

ker9 · Accepted 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!