We have a table of goals, and a table of milestones. We want to pull in all the milestones for each goal into our table and then view them as a subtable. Use the Lookup formula.
Your answer:
Goals
0
Goal
Description
Related Milestones
Goal
Description
Related Milestones
1
Goal 1️⃣
Why Objective #1 is important!
2
Goal 2️⃣
Why Objective #2 is important!
3
Goal 3️⃣
Why Objective #3 is important!
4
Goal 4️⃣
THIS IS REALLY IMPORTANT
There are no rows in this table
Milestones
0
Goal
Key Result
Score
Goal
Key Result
Score
Goal 1️⃣
Milestone #1
00
3
Milestone #2
00
5
Goal 2️⃣
Milestone #3
00
9
Milestone #4
00
6
Goal 3️⃣
Milestone #5
00
8
Goal 4️⃣
Milestone 5
00
2
Reveal answer
Goals Answer
0
Goal
Description
Related Milestones
Goal
Description
Related Milestones
1
Goal 1️⃣
Why Objective #1 is important!
Milestone #1
MIlestone #56
Milestone #2
2
Goal 2️⃣
Why Objective #2 is important!
Milestone #3
Milestone #4
3
Goal 3️⃣
Why Objective #3 is important!
Milestone #5
There are no rows in this table
Milestones Answer
0
Goal
Key Result
Score
Goal
Key Result
Score
Goal 1️⃣
Milestone #1
00
5
MIlestone #56
00
10
Milestone #2
00
5
Goal 2️⃣
Milestone #3
00
9
Milestone #4
00
6
Goal 3️⃣
Milestone #5
00
8
Exercise 2
We have a table of goals, and a table of milestones. We want to pull in all the milestones for each goal into our table and then view them as a subtable. Use the Filter formula.
Your answer:
Goals - Exercise 2
0
Goal
Description
Related Milestones
Goal
Description
Related Milestones
1
Goal 1️⃣
Why Objective #1 is important!
2
Goal 2️⃣
Why Objective #2 is important!
3
Goal 3️⃣
Why Objective #3 is important!
There are no rows in this table
Milestones - Exercise 2
0
Goal
Key Result
Score
Goal
Key Result
Score
Goal 1️⃣
Milestone #1
00
4
Milestone #2
00
5
Goal 2️⃣
Milestone #3
00
9
Milestone #4
00
6
Goal 3️⃣
Milestone #5
00
8
Reveal answer
Goal
Description
Related Milestones
Goal
Description
Related Milestones
1
Goal 1️⃣
Why Objective #1 is important!
Milestone #1
Milestone #2
2
Goal 2️⃣
Why Objective #2 is important!
Milestone #3
Milestone #4
3
Goal 3️⃣
Why Objective #3 is important!
Milestone #5
There are no rows in this table
Milestones - Exercise 2 2
0
Goal
Key Result
Score
Goal
Key Result
Score
Goal 1️⃣
Milestone #1
00
7
Milestone #2
00
1
Goal 2️⃣
Milestone #3
00
1
Milestone #4
00
2
Goal 3️⃣
Milestone #5
00
1
Exercise 3
Now, we don’t want to see all related milestones. We want to create a select list that only has the milestones related to the goal in the row. Use the Lookup formula.
Your answer:
Goals 2
0
Goal
Milestone
Update
Goal
Milestone
Update
1
Goal 1️⃣
2
Goal 2️⃣
3
Goal 3️⃣
There are no rows in this table
Milestones 2
0
Goal
Milestone
Score
Goal
Milestone
Score
Goal 1️⃣
Milestone #1
00
4
Milestone #2
00
5
Goal 2️⃣
Milestone #3
00
9
Milestone #4
00
6
Goal 3️⃣
Milestone #5
00
8
Reveal Answer
Goal
Milestone
Update
Goal
Milestone
Update
1
Goal 1️⃣
Milestone #1
2
Goal 2️⃣
Milestone #4
3
Goal 3️⃣
There are no rows in this table
Goal
Milestone
Score
Goal
Milestone
Score
Goal 1️⃣
Milestone #1
00
4
Milestone #2
00
5
Goal 2️⃣
Milestone #3
00
9
Milestone #4
00
6
Goal 3️⃣
Milestone #5
00
8
Milestone #6
00
2
Exercise 4
Now, we don’t want to see all related milestones. We want to create a select list that only has the milestones related to the goal in the row. Use the Filter formula.
Your answer:
Goals - Exercise 4
0
Goal
Milestone
Update
Goal
Milestone
Update
1
Goal 1️⃣
2
Goal 2️⃣
3
Goal 3️⃣
There are no rows in this table
Milestones - Exercise 4
0
Goal
Milestone
Score
Goal
Milestone
Score
Goal 1️⃣
Milestone #1
00
4
Milestone #2
00
5
Goal 2️⃣
Milestone #3
00
9
Milestone #4
00
6
Goal 3️⃣
Milestone #5
00
8
Reveal Answer
Goals - Exercise 4 2
0
Goal
Milestone
Update
Goal
Milestone
Update
1
Goal 1️⃣
2
Goal 2️⃣
3
Goal 3️⃣
There are no rows in this table
Milestones - Exercise 4 2
0
Goal
Milestone
Score
Goal
Milestone
Score
Goal 1️⃣
Milestone #1
00
4
Milestone #2
00
5
Goal 2️⃣
Milestone #3
00
9
Milestone #4
00
6
Goal 3️⃣
Milestone #5
00
8
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (