Cross doc with multiple tables
Share
Explore

Advanced version

Use a button + formula + automation + cross doc to pull all the other tables into one.
Requirements: Cross Doc Pack, Formulas (Formula Map), Buttons, Automations
First sync in your tables like we did for our scenario.
If you'd prefer to see all of the individual projects in one place it is possible to union them all in one table (note this is much easier if they all of the same columns/schema). Using a formula map and button action we can map each column from our synced table to this table.
For example the below formula would add all current Ice Cream Team projects to the table:
[Ice Cream Projects].FormulaMap(AddOrModifyRows([Project Roll Up],Project=CurrentValue)
You can then expand this to all the other columns and repeat it for other tables. You can run these as separate buttons for each table and have a button that pushes each of them for you. You can even create an automation to push this every hour to keep it all in sync.
Update Ice Creams
Update Go Kart
Update Arcade
Update all projects
Project Roll Up
1
Team
Project
Description
Project Lead
Percent Complete
1
Ice Cream
Make our Ice Cream machine
Get the new ice cream machine up and running.
Adam Ginzberg
50%
2
Ice Cream
Design the menu
Create our new menu for fall
Glenn Jaume
33.333333333333326%
3
Go Kart
Build Race Track
Get our race track ready for launch day
Alex DeNeui
80%
4
Go Kart
Marketing
Make sure everyone knows about launch day
Helena Jaramillo
75%
5
Go Kart
Go-karts
Get all the karts ready for launch day
MV
Michael Varney
50%
6
Arcade
Prizes
Keep our prize system working well
Joe DiMento
0%
7
Arcade
Arcade Machines
Maintain and improve our Arcade
Glenn Jaume
25%
8
Arcade
Bowling Alley
Building our new bowling alley
MC
Monica Caso
50%
There are no rows in this table
45.42%
Average




Update all projects

Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.