Rollup/Formula for SUM of quantities attached to a linked record

Hi all - I’m new to Airtable, we use it at the Transportation Authority I work for. What I am looking to do is create a database of bus schedules by their shipping quantities (amount). Most schedules are distributed to multiple locations, which I have a table for each. Quantities of schedules per route vary from location to location. I am trying to get the total quantity of each schedule - across all tables - to the Total page, where I can view the grand total quantity per route.

I thought I was able to use the rollup feature, but I cannot get it to link multiple columns to provide me with the outcome I am looking for. Maybe I need a formula?

Any assistance is greatly appreciated. Thank you in advance!

HI @John_Semerjian,

Welcome to Airtable Community ! :smiley:

You cannot Rollup data from Multiple tables. I don’t think the best option for you is to have a separate table for each location. How about you put all the data in one table and you use the Group By option to separate the locations?

BR,
Mo

Thank you for the reply!

Your suggestion makes complete sense - I’m going to do that!

Thank you,
John

1 Like