Automated RYG Balls

Options

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

Comments

  • Chris McKay
    Chris McKay ✭✭✭✭✭✭
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!