How to automate the RYG status balls

Janice Phua · 05/27/21

I need help to automate the RYG status balls in the "Status" column, depending on the "% Complete" for each request.

This is my formula but it kept showing "Red" though I have % Complete is 75% and 100%

=IF([% Complete]@row < 70, "Red", IF([% Complete]@row > 70, "Yellow", IF([% Complete]@row = 100, "Green")))

Requirement:

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

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

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

Bassam Khalil · 05/27/21

Hope you are fine,please use the following formula:

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

the following screenshot shows the result:

Bassam Khalil · 05/27/21

Hope you are fine,please use the following formula:

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

the following screenshot shows the result:

Janice Phua · 05/27/21

Thank you @Bassam Khalil it works now 😀

Bassam Khalil · 05/27/21

You are welcome and I will be happy to help you any time.

Bassam Khalil · 05/27/21

I will be grateful for your "Vote Up" or "Insightful".

Formulas and Functions