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

[John_Semerjian]

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!

[Mohamed_Swella1]

HI @John_Semerjian,

Welcome to Airtable Community ! :grinning_face_with_big_eyes:

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

[John_Semerjian]

Thank you for the reply!

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

Thank you,
John