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!
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?