RYG Ball Help!

Tony Davidson - SmartSheet Certified User 2016

I am driving myself crazy as I know I'm missing something really simple for this RYG formula. I have an actions completed column that could be anywhere from 0 to 100% complete based on 5 tasks that need to be completed. I have setup the RYG column with this formula below and it's not working. Please help me..what am I missing here? Thanks!

=IF([Actions Completed %]23 = (100), "Green", IF([Actions Completed %]23 <= (100), "Yellow", IF([Actions Completed %]23 = (0), "Red")))

Find more posts tagged with

Formulas

Comments

Benjamin Walker

If your column is formatted as a % you should try using

[Actions Completed %]23 = 1

I'm not sure what you are trying to achieve with the formula, right now it looks like if the value is ever not 100%, it will go to yellow.

Tony Davidson - SmartSheet Certified User 2016

I'm trying to get the following:

100% = Green

under 100% = Yellow

0% = Red

Benjamin Walker

Here you are (if your column is % formatted):

=IF([Actions Completed %]23 = 1, "Green", IF([Actions Completed %]23 = 0, "Red", IF([Actions Completed %]23 <= 1, "Yellow")))

I think this should work for your use!