Exercise 1
I want to bring in all of our team information so I can reference it.
Reveal Answer
Search
Row
Team
Motto
1
Dog Team
Dog Team
Will sit for treats
2
Cat Team
Cat Team
Birds are yummy
3
Bird Team
Bird Team
Nest building is our thing
4
Squirrel Team
Squirrel Team
We climb trees
There are no rows in this table
Exercise 2
I want every team to have access to their tasks, but I don’t want them to see the other team’s work.
Reveal Answer
Search
Row
Project
Owning Team
Budget
Progress
1
Play area improvements
Play area improvements
Dog Team
$9.00
2
Kibble Review
Kibble Review
Dog Team
$500.00
There are no rows in this table
Exercise 3
I want to use the project information in a task table.
Reveal Answer
Project
Task
Complete?
Play area improvements
4
Evaluate tennis ball vendors
Paint fences
Bring your kong program
Paw washing station
Kibble Review
2
Create kibble shortlist
Schedule taste test
Exercise 4
I want to update our progress in the source doc from our team doc.
Reveal Answer
Search
Row
Project
Owning Team
Budget
Progress
Update Progress
1
Play area improvements
Play area improvements
Dog Team
$9.00
Update progress
2
Kibble Review
Kibble Review
Dog Team
$500.00
Update progress
There are no rows in this table
Project
Task
Complete?
Play area improvements
4
Evaluate tennis ball vendors
Paint fences
Bring your kong program
Paw washing station
Kibble Review
2
Create kibble shortlist
Schedule taste test
Exercise 5
I want to add new projects to our source doc.
Reveal Answer
Proposed project
Team
Why we should do it
Budget
Fund project
1
Cat Alliance
Dog Team
We’re better together!
$640.00
Fund project
2
Birdcall Training
Bird Team
We’d like to learn from each other
$1,500.00
Fund project
3
Nut Nutrition Education
Squirrel Team
Are peanuts healthy?
$4,000.00
Fund project
There are no rows in this table
Exercise 6
When projects complete, I want to delete a row in the source doc for the project.
Reveal Answer
Search
Row
Project
Owning Team
Budget
Progress
Archive Project
1
Play area improvements
Play area improvements
Dog Team
$9.00
Archive Project
2
Kibble Review
Kibble Review
Dog Team
$500.00
Archive Project
There are no rows in this table
Exercise 7
I want to push a button that notifies our project leads with a request for more budget.
Reveal Answer
Search
Row
Project
Owning Team
Budget
Progress
Request more budget
Update Progress
1
Play area improvements
Play area improvements
Dog Team
$9.00
Request more budget
Update progress
2
Kibble Review
Kibble Review
Dog Team
$500.00
Request more budget
Update progress
There are no rows in this table
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.