Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to make a formula field that adds to itself

Topic Labels: Formulas
1089 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Edward_Zev
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
kuovonne
18 - Pluto
18 - Pluto

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