Hi,
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.
