How to make an =SUM formula return zero when cells in the formula are blank?
I'm making a simple smartsheet and have a column adding several cells. Then have a status ball change colors based on certain numerical conditions. I need the SUM formula to remain blank and not 0 because blank is blue (not started) and 0 is green meeting goal. Thanks in advance for any assistance.
Help Article Resources
Check out the Formula Handbook template!