Skip to content
Gallery
How to build tasks dependencies with durations in Google Sheets, ClickUp, Monday, Wrike, SmartSheet, Notion, and Coda
Share
Explore
Task dependencies template
Simple list of tasks and dependencies with task start dates that adjust based on dependencies. View tasks and dependencies on a calendar and gantt chart.
Start date of first task: 10/1/2020
10/1/2020
All Tasks
Task Name
Dependency
Duration
Team
Owner
Task Start Date
Task End Date
Dep Start Date
Dep End Date
1
Instructor Shoot
5 days
Creative
10/1/20
10/6/20
2
GTM planning kicked off
Instructor Shoot
1 day
Marketing
10/6/20
10/7/20
10/1/20
10/6/20
3
Portraiture photography selected
Instructor Shoot
2 days
Marketing
10/6/20
10/8/20
10/1/20
10/6/20
4
Class editing
Instructor Shoot
3 days
Engineering
10/6/20
10/9/20
10/1/20
10/6/20
5
Complete class trailer
Class editing
3 days
Creative
10/9/20
10/12/20
10/6/20
10/9/20
6
Complete class workbook
Class editing
5 days
Creative
10/9/20
10/14/20
10/6/20
10/9/20
7
Class finishing
Class editing
4 days
Marketing
10/9/20
10/13/20
10/6/20
10/9/20
8
Test class on site
Class finishing
1 day
Marketing
10/13/20
10/14/20
10/9/20
10/13/20
9
Site copy
GTM planning kicked off
2 days
Creative
10/7/20
10/9/20
10/6/20
10/7/20
10
Social media posts prepared
GTM planning kicked off
1 day
Engineering
10/7/20
10/8/20
10/6/20
10/7/20
11
Class branding finalized
Site copy
1 day
Marketing
10/9/20
10/10/20
10/7/20
10/9/20
12
Engineering sign off
Test class on site
3 days
Engineering
10/14/20
10/17/20
10/13/20
10/14/20
13
Launch 🚀
Test class on site
2 days
Engineering
10/14/20
10/16/20
10/13/20
10/14/20
14
Promote on social media
Launch 🚀
1 day
Marketing
10/16/20
10/17/20
10/14/20
10/16/20
There are no rows in this table
Gantt chart of All Tasks
Instructor Shoot
GTM planning kicked off
Portraiture photography selected
Class editing
Complete class trailer
Complete class workbook
Class finishing
Test class on site
Site copy
Social media posts prepared
Class branding finalized
Engineering sign off
Launch 🚀
Promote on social media
Apr 2024
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
May 2024
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Jun 2024
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Jul 2024
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Aug 2024
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Sep 2024
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Oct 2024
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Nov 2024
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Dec 2024
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Month
TodayFit
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.