How to make a formula field that adds to itself

Topic Labels: Formulas
564 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I have print shop.
And I have a need to calculate the useful usage of printing roll.
For example, I know that the roll is 100meters, so if I add all printed jobs between replacements (ex.89meters), I know that my useful usage is 89%.
So I have this table with fields (order#, meters, date roll changed, #number5) where #number5 right now filled manually.
How can I replace it with formula field doing same comulative function between roll changes.
2022-01-15 11.06.37 am

1 Reply 1

This is one way where Airtable is very different from a spreadsheet. What you want is a running total, and Airtable formulas cannot calculate a running total (at least not without resource intensive workarounds).

I suggest one of the following

  • using a linked record field for the roll with a rollup to sum the meters used
  • looking into the running total script