The Community will be undergoing maintenance from Friday February 21 - Friday, February 29 and will be "read only" during this time. To learn more, check out our Announcements blog post.
Is there a way to do a SUM formula that doesn’t just count the one record it’s attached to but includes previous ones? So like:
A B
10 =SUM(A1)
15 =SUM(A1+A2)
10 =SUM(A1:A3)
So I can add a number into Column A and have a running total in Column B. In the example above it would Column B would read 10, 25, 35
Unfortunately, trying to implement your example would trigger Airtable’s safeguards against circular references. That said, there are ways to get around this limitation, although they require [minimal] manual intervention. In an earlier post and demo base, I show how to create several different types of running totals. Admittedly, none is very pretty; on the bright side, you can often drop the provided routines into your base and henceforth forget about them…