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
Instructor Shoot
5 days
Creative
10/1/20
10/6/20
GTM planning kicked off
Instructor Shoot
1 day
Marketing
10/6/20
10/7/20
10/1/20
10/6/20
Portraiture photography selected
Instructor Shoot
2 days
Marketing
10/6/20
10/8/20
10/1/20
10/6/20
Class editing
Instructor Shoot
3 days
Engineering
10/6/20
10/9/20
10/1/20
10/6/20
Complete class trailer
Class editing
3 days
Creative
10/9/20
10/12/20
10/6/20
10/9/20
Complete class workbook
Class editing
5 days
Creative
10/9/20
10/14/20
10/6/20
10/9/20
Class finishing
Class editing
4 days
Marketing
10/9/20
10/13/20
10/6/20
10/9/20
Test class on site
Class finishing
1 day
Marketing
10/13/20
10/14/20
10/9/20
10/13/20
Site copy
GTM planning kicked off
2 days
Creative
10/7/20
10/9/20
10/6/20
10/7/20
Social media posts prepared
GTM planning kicked off
1 day
Engineering
10/7/20
10/8/20
10/6/20
10/7/20
Class branding finalized
Site copy
1 day
Marketing
10/9/20
10/10/20
10/7/20
10/9/20
Engineering sign off
Test class on site
3 days
Engineering
10/14/20
10/17/20
10/13/20
10/14/20
Launch 🚀
Test class on site
2 days
Engineering
10/14/20
10/16/20
10/13/20
10/14/20
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
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
Jan 2025
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
Feb 2025
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
Mar 2025
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
Apr 2025
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 2025
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 2025
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 2025
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 2025
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.