Re: Airtable simple maths, please help! I will put in the start record everyday, and the used KG from yesterday. a formula will calculate the yesterday finish record. please see picture
Airtable is not a spreadsheet, it is a database. So unlike a spreadsheet, there is no way for one record (row) to see the values from another record (row) unless you manually link to that record using a “linked record field”, and then you can lookup the values from that record using a “lookup field”.
I don’t cover too much math in my free Airtable training course, but I do cover linked record fields & lookup fields, so you can understand the basics of linked records & lookup fields:
