Gallery
Cross doc with multiple tables
Share
Explore
Gallery
Cross doc with multiple tables

Intermediate - Formula

Sync in all tables and calculate how complete each project is in a table
Requirements: Cross Doc Pack, Formulas (SwitchIF , Filter)
First sync in your tables like we did for our
Simple
⁠
scenario.
With your team project tables synced in you can reference them all in one table to extra summary data such as percentage complete.
Below we pull in all of the Tasks and Task Stages with a SwitchIF() formula which matches the rows team with the correct table to pull data from. We then can do a simple calculation to see how many of the tasks are completed or not across all of a teams projects.

All Team Tasks & Projects
1
Team
Text
Tasks
Task Stages
Percent Complete
1
Ice Cream
See teams doc
Order Novembers prizes
Install Killer Queen Machine
Fix Street Fighter Controls
Reduce ticket value of old prizes
Maintenance for Wizard of Oz Pinball
Purchase new Dance Dance machine
Finish branding
Install and test lane 1
Install and test lane 2
Install and test lane 3
Purchase balls
Create food and drinks menu
Go to toy fair expo for research
In ProgressCompleteNot StartedNot StartedIn ProgressNot StartedCompleteCompleteCompleteIn ProgressIn ProgressNot StartedNot Started
31%
2
Go Kart
See teams doc
Land purchase
TV Ads
Local Paper Ads
Build Structure
Design Track
Build Track
Test Run
Build Website
Radio Ads
Go-Kart 1 ready
Go-Kart 2 ready
Go-Kart 3 ready
Go-Kart 4 ready
Go-Kart 5 ready
Go-Kart 6 ready
Go-Kart 7 ready
Go-Kart 8 ready
CompleteIn ProgressCompleteCompleteCompleteCompleteIn ProgressCompleteCompleteCompleteCompleteCompleteCompleteBlockedIn ProgressNot StartedNot Started
65%
3
Arcade
See teams doc
Order Machine
Strawberry Swirl
Just Vanilla
Build Machine
Cheesecake
CompleteIn ProgressCompleteBlockedNot Started
40%
There are no rows in this table
⁠

⁠
Update all projects
⁠
View of 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
⁠





OLD Multi button solution
⁠
Update Ice Creams
⁠
⁠
⁠
Update Go Kart
⁠
⁠
⁠
Update Arcade
⁠
⁠
Gallery
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.