Skip to main content

Hello folks, 

I am new to Airtable, any help is highly appreciated. 

I have different tables under the same base that tracks existing inventory and sales. I would like to create a third table that summarizes data for example I would like each row to represent a month and calculate profit/loss for that month but if I use rollup or formula fields it will apply the same formula into entire column which doens’t help my case. I need unique calculations to be carried for each row as each row will represent a month. 

Figured it out, in case someone else is having the same problem, Here is what I did

I Created a link to each table from summary table and added links for the records that were relevant for that specific row and then used rollups to calculate sums. 

Exactly! For future readers, here you can find more info on Rollup fields. 

Reply


Terms & Conditions