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

Von Gossi

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

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!

ker9

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!

Von Gossi

Hi @ker9 - it worked! Thank you.

My mistake was not converting the % to decimals and I was doing it in Ascending order vs. descending!

Thank You!