Advanced
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
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
Team
Project
Description
Project Lead
Percent Complete
Ice Cream
Make our Ice Cream machine
Get the new ice cream machine up and running.
50%
Ice Cream
Design the menu
Create our new menu for fall
33.333333333333326%
Go Kart
Build Race Track
Get our race track ready for launch day
80%
Go Kart
Marketing
Make sure everyone knows about launch day
75%
Go Kart
Go-karts
Get all the karts ready for launch day
50%
Arcade
Prizes
Keep our prize system working well
0%
Arcade
Arcade Machines
Maintain and improve our Arcade
25%
Arcade
Bowling Alley
Building our new bowling alley
50%
There are no rows in this table
45.42%
Average
Update all projects
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.