Increase value of a cell with the previous register

Question

HELLO!
What fx do I have to build in “copy”, so that the value of the cell below is the summation with the value above?

[quote=“Serge_Lacasse, post:1, topic:29840, full:true”]

Hugo_Mongay · Accepted Answer

Thanks a lot!!!, thats wt I need.

Justin_Barrett · Answer

Because Airtable’s data structure is more akin to a database than a spreadsheet, cells can’t directly reference other cells. There are ways to work around this, but they’re complex. If you’d like to read more, this is the thread you want:              Multi-record calculations (c.f. 'running balance,' 'row number,' and the like) Show and tell        tl;dr version: A frequent query and/or complaint concerns users who wish to access data from a record for use in a calculation performed in a different record from the same table. Often this takes the form of a user asking ‘how to retrieve a value based on row number’; other times the user wishes to perform a calculation that assumes knowledge of the previous record — for instance, maintaining a running balance. A recently published base contains four approaches to this problem, three involving …

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded