Leave blank if SUM is zero
Options
Tina Rustvold
✭✭✭✭✭
I found a few answer that I though would work for us, but I keep getting an Incorrect Argument error. I want to sum numbers in columns for a total, but leave the total blank if the sum is zero. Here is what I was trying:
=IF(COUNT([MD FTE]:[MD FTE] > 0, IF([APP FTE]:[APP FTE] > 0, SUM([MD FTE]:[MD FTE], [APP FTE]:[APP FTE], ""))))
Thanks!
Tags:
Answers

Try this formula in your Total FTE column then convert to column formula:
=IF(SUM([MD FTE]@row:[APP FTE]@row) = 0, "", SUM([MD FTE]@row:[APP FTE]@row))
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!