Excluding Blank Cells in Formula

I have a master row that I would like to track the year's progress. In my image,

I would like the [Status] ball to stay Green if "YES" and if blank in [Count] cells January - December. Want it to turn Red, if there is a "NO" in any [Count] cell. If all [Count] cells are blank January - December then "Blue"

YES followed by blank =Green

Any NO =Red

All blank=Blue

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!