Intermediate
Intermediate - Formula
Sync in all tables and calculate how complete each project is in a table
Requirements: Cross Doc Pack, Formulas (SwitchIF , Filter)
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
Team
Text
Tasks
Task Stages
Percent Complete
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%
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%
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
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
OLD Multi button solution
Update Ice Creams
Update Go Kart
Update Arcade
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.