# Automated RYG Based on % Complete Formula Help

Options

Hi,

I'm trying to automate the RYG colored balls so they automatically change colors based on the percent complete entered. I watched a video, read through the suggestions from the community, and was unable to come up with a formula that worked correctly. Can you please help me identify the error in my formula?

When I enter in each element of the formula separately, they work. However, I am unable to combine them successfully.

Separately:

=IF([% Complete]3 = 1, "Green"),

=IF([% Complete]3 <= .50, "Red"),

=IF([% Complete]3 <= .99, "Yellow")

Combined:

=IF([% Complete]3<= 0.50), "Red"), IF([% Complete]3<=0.99, "Yellow"), IF([% Complete]3= 1,"Green")))

Thanks,

Susie

Tags:

• ✭✭✭✭✭✭
Options

Hi Susy, You have a lot of closing parenthesis that are unnecessary. A nested if statement can't close until the end. Try this revised version. I replaced the row number with an @row identifier which will find the value at that row. You can also make this a column formula by right-clicking on it after you put it in a column.

=IF([% Complete]@row<= 0.50, "Red", IF([% Complete]@row<=0.99, "Yellow", IF([% Complete]@row= 1, "Green")))

For more about Column Formulas see:

• ✭✭✭✭✭✭
Options

Hi Susy, You have a lot of closing parenthesis that are unnecessary. A nested if statement can't close until the end. Try this revised version. I replaced the row number with an @row identifier which will find the value at that row. You can also make this a column formula by right-clicking on it after you put it in a column.

=IF([% Complete]@row<= 0.50, "Red", IF([% Complete]@row<=0.99, "Yellow", IF([% Complete]@row= 1, "Green")))