Show Balance in a formula for all the column


I need to make a formula to show the balance in the entire column, but the formula column do not works properly.

I have doposit, cost and balance. Deposit (sum), cost (diference), balance is the deposit less cost and the next row is balance plus doposit less cost and show the new balance.

We need to copy when my rows fill all??

=Saldo597 - TOTAL@row + Reembolso@row

thanks for your help


  • Eric Law
    Eric Law ✭✭✭✭✭✭

    Sorry, can't @ you for some reason. Your formula has Saldo597 in it which is a static cell, which I am assuming is 220.77. If you need a total for your balance, I would recommend you either use sheet summary, =SUM(Saldo:Saldo), or create a new column that has total balance =SUM(Saldo:Saldo). Your Saldo formula should be =IFERROR(TOTAL@row + Reembolso@row, 0)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!