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!
Cecelia@SAG
Comments
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!