Aug 06, 2019 07:38 PM
I’m trying to write a formula that calculates the sum of values in another column. The tricky part is I want each row to add only the numbers above it in this other column, adjusting each time it goes down the row. For example:
DATE EPISODES PRODUCED TODAY TOTAL EPISODES PRODUCED
7/11 2 2
7/12 3 5
7/13 1 6
Where the “TOTAL EPISODES PRODUCED” column is automatically tracking what’s being input into the “EPISODES PRODUCED TODAY” column.
Aug 06, 2019 08:04 PM
This type of running tally can be done in Airtable (and somewhere in this forum I’m pretty sure there’s a post that either documents the process, or links to a sample base showing how it’s done), but it takes some heavy table mangling to do it because databases just aren’t designed for this kind of thing. Unlike cells in a spreadsheet, records (rows) in a database have no knowledge of each other, so there’s no database equivalent of “look a this cell in the previous row, add something to it, then display the result.”
I would strongly suggest reexamining your base/table setup if you want this kind of running tally, and possibly reconsider the tally’s importance completely. While it’s a common thing to do with spreadsheets (mainly because it’s so easy), I find that it’s rarely of much practical use in the long run.
And if you say, “I still want to do it. Please tell me how?”, I’m afraid I can’t help you. I’ve glanced at other bases where it’s been done, but haven’t taken the time to learn the process myself because I haven’t felt that it would add any value to anything I’m doing. Sorry!
Aug 06, 2019 10:14 PM
Something similar was accomplished in the responses to this thread:
With solutions provided by @bdelanghe, @W_Vann_Hall, and myself. Its been so long since I made that base I have forgotten how it works lol. Hopefully the thread will help you out. If not, I could probably re-figure this out.
Aug 07, 2019 03:34 PM
Thanks so much y’all!