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

[LAZY_APACHE]

[LAZY_APACHE]

See 7000 -1000 = 6900 and fill up the cell for me just like in Morocsoft excel, please help

[ScottWorld]

Welcome to the community, @LAZY_APACHE!

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:

LinkedIn

Learning Airtable Online Class | LinkedIn Learning, formerly Lynda.com

Learn the basics of Airtable, a spreadsheet-database platform, including how to create tables, use different types of fields, leverage views, work with records, link tables, and more.