Automated RYG Balls
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!
Help Article Resources
Check out the Formula Handbook template!