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.