Rolling up data from different tables into one

Topic Labels: Base design
403 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast


Imagine the following scenario:

  • A company has two subsidiaries
  • Each subsidiary has multiple teams
  • Each team can be assigned tasks
  • Users from one subsidiary don’t have the right to access the other’s data

I’ve set it up so each subsidiary has one base with a table that looks like this:

Team name Assigned tasks
Team name 1 Task 1, Task 4
Team name 2 Task 2
Team name 3 Task 3, Task 5

My plan is to use Multi-Source Sync feature to pull each region’s table into a new base.

In this new base, how can I create a table that counts the number of tasks per region:

Region name Assigned Tasks
Region name 1 4
Region name 2 2

I imagine it can be done using a roll-up field, but each region’s data is in its own table…

Hopefully, this makes sense. If you’ve encountered something similar, let me know how you did it.

1 Reply 1
5 - Automation Enthusiast
5 - Automation Enthusiast

Following up on this thread I posted about a week ago. Hoping someone will be able to help.

Let me know if more info would be helpful about my goal or the sample scenario I shared.