Sum of column when moving rows


When I move rows to a destination sheet, I need to have a running sum of one particular column as each row is added.

I've tried doing a sum of children (but the moved row comes in at the wrong position) or just an auto sum at the top of the sheet but when new rows are added, they don't get summed.

Is there an easy way to accomplish this?

Best Answer

  • MCorbin
    MCorbin Overachievers Alumni
    Answer ✓

    =SUM([Column 2]:[Column 2])

    This will only work if you put the formula in a different column. In my example, the formula is in Column 1 and adding up all the values in Column 2

    Alternately, you could put the same formula in the sheet summary and you wouldn't have to add the new column.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!