#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# RYG Ball Help!

Options
edited 12/09/19

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

Tags:

• Employee
Options

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.

• Options

I'm trying to get the following:

100% = Green

under 100% = Yellow

0% = Red

• Employee
Options

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!

• Options

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

This discussion has been closed.