Feb 26, 2017 04:47 AM
I can’t find a solution for this in my opinion very common task: I want to get a balance over rows.
I.e. if I track working hours, I’d like to have a field in the row with the sum of all previous working hours till that day.
Date : Work : Balance
: :
01.03. : +3,00 : 3,00
02.03. : +3,00 : 6,00
03.03. : +2,00 : 8,00
04.03. : -3,50 : 4,50
05.03. : +4,00 : 8,50
I can’t find a formula that allows me to address a special field in the row above the actual row. Is there a solution for this in Airtable?
Sep 11, 2017 06:50 PM
I have a similar need. I am tracking expenses and want to keep a running balance, subtracting expenses from a budget amount so each line gives the running available balance. Hopefully my comment will help someone respond to yours and we can both get an answer.
Sep 18, 2017 03:47 AM
Hi there, I too am looking for this and can’t really believe that it isn’t possible. Essentially -1 operation to the row above. Can anyone help, please??
Sep 26, 2017 05:15 AM
@Cindee_Nielsen, @nealtz as well…
Unlike in a spreadsheet, row order and relative positioning carry no significance in Airtable, so the row-based formula definitions you’re looking for don’t exist. That said, it is possible to calculate running balances, day-to-day variation, and the like: Instead of an implicit link based upon row position, you simply need to find a way to create and follow explicit links tied to the record ID. A few days ago, as a reply to a post with a very innocuous title, I posted a discussion of one method of implementing a running total or tracking day-to-day change with Airtable. That post (and, now this one as well) also contains a link to an example base demonstrating this approach.
Hope this is of some assistance!
Mar 22, 2018 05:06 PM
Thanks for sharing your method. This seems like an incredibly complex way to do something that would be a simple expression in excel. I understand that Airtable is not really excel (just mean to look like it), and we’re dealing with a database, but even in a DB, you could query a previous entry. There seems like there should be an easier way to do this. Anyone else figure this out?
Mar 23, 2018 07:24 AM
There hasn’t been any changes in the Airtable interface that would allow that, unfortunately. I believe Fieldbook (which is a different site entirely) allows you to do a database search based on a value (so something like {Date} -1
), but the syntax is quite different from Airtable (that is, entirely unlike Excel).
Mar 23, 2018 01:25 PM
Thanks. Has anyone submitted this as a feature request to Air Table? Seems like something worth asking for…
Jun 06, 2019 01:03 AM
I don’t know if anyone else has worked out this work around. Basically i am able to get a cashflow schedule working by:
Its a bit manual but once its set up you can copy and paste the previous entry and add the current entry.
Hope this helps