Sum FUnction Not working properly


I am trying to get the total value for a column and the math is completely off. has anyone encountered this? all i am doing is a simple sum. the total should be 703 not 595


  • heyjay
    heyjay ✭✭✭✭✭

    Can you try to remove the numbers one by one and see what row/number is not affecting the formula.

    When you remove the number bring it back when you jump on the next row.


  • Jim B
    Jim B ✭✭✭

    Hello, I came here looking for an answer to a similar problem. Didn't find it here but I did figure it out eventually.

    I was pulling numbers from other sheets into my formula which was not calculating as expected.

    My fix was to make sure each cross sheet reference was converted from text into a number using VALUE(yourreference@row) in the cell where I had my formula.

    I know this is an old thread. Just leaving this here in case someone else needs it.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!