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
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!