Automated RYG Balls

Cecelia@SAG

Greetings Smartsheet Community!

I am working on a formula to automate the RYG balls in a status column that references data in the cells of 3 columns, and it seems to be working well.  I am wondering if there is a way to add to the formula so that the status column stays blank until the data in the reference cells is actually entered so I don't have a column of "Red" status balls in the blank sheet?

Here is the formula I'm using:

=IF(AND[XY1]16=5),"Green", IF(AND[XY2]16=3),"Yellow", IF(AND[XY3]16=0),"Red")))

Thanks so much for any assistance you can offer!

Cecelia@SAG

Chris McKay

Hi Cecelia,

You were 99% of the way there. You just need to enter a "" (blank space) in the value_if_false condition:

=IF(AND[XY1]16=5),"Green", IF(AND[XY2]16=3),"Yellow", IF(AND[XY3]16=0),"Red","")))

Kind regards,

Chris McKay