Automate RYG Balls

bmangam456

Hello! I am trying to automate the cells so that when a specific value is entered, it will return a colored ball in the same cell

Example: 0 = Red ball, .6= Yellow Ball, 1= Green Ball

and

0%-30%= Red, 31%-70% = Yellow, 71%-99% = Green, 100% = Gray

Can you please let me know how I can achieve this?

Thank you

Paul Newcome

=IF([% Complete]@row <= .3, "Red", IF(AND([% Complete]@row > .3, [%Complete]@row <= .7), "Yellow", IF(AND([%Complete]@row > .7, [%Complete]@row < 1), "Green", IF([%Complete]@row = 1, "Gray", ""))))

Give this a try. Just change [%Complete] to the column name your percentages are in.

bmangam456

Thank you! That worked!