I am new to glide and I am trying to create an expense tracker for my personal use, just to get off the ground with a real project. I have the following columns: date, amount,balance, category. When I enter the amount, I want the balance to be updated by taking the previous balance (from the prev…

I’d probably write the previous balance when creating each row, then use a math column to figure out the new balance based on the credit or debit. You could get that previous balance before creating a new row by using a Single Value column or a Rollup column. Either way you should have a balance v…

How to auto-calculate one of the 2 fields - amount and balance - to update based on the value in another

Ask for Help

Eric_Penn March 30, 2023, 8:03pm 8

Some ideas discussed here.

Topic		Replies	Views
math formula Ask for Help	12	2342	March 11, 2021
Formula to cumulatively add and subtract two columns Ask for Help	5	632	February 22, 2023
Diffferent formula from Row 2 onwards Ask for Help	2	36	August 2, 2024
Data: Balancing Daily Expenses with Previous Day's Balance Ask for Help	3	85	April 17, 2024
How to create a cumulative sum of rows in a columns Ask for Help	15	2159	November 24, 2023

How to auto-calculate one of the 2 fields - amount and balance - to update based on the value in another

Related topics