Keeping a running balance



I have a simple sheet that I am using to track bursary payments. Each time we make a payment I want the column with the total budget left to decrease based on the amount that we have given as a bursary.

How can I do that?

I tried =SUM(100000 - Cost@row) but all this is doing for each row is taking away that row amount for each row - I need it to be cumulative ...



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!