Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Aug 16, 2021 08:37 AM
Hi,
Imagine the following scenario:
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.
Aug 25, 2021 03:24 AM
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.