Question about Sum Function

Hi all - I met an interesting bug when using sum formula in Smartsheet. I used sum function to calculate the total of above 6 cells. It should show 6, not 2.

Each cell except the last total is using formula to calculate sum of each row. I use "+" because feb-28 and Feb-29 are added temporarily.

Only Feb 28 & Feb 29 columns have numbers for now.

Wondering why the sum function does not add all numbers together.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!