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")))

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! 

Tony Davidson - SmartSheet Certified User 2016

Yes!!  Works like a charm..you rock  Thank You!!