Cross doc with multiple tables
Share
Explore

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 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
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
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
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
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.