Skip to content
How to build tasks dependencies with durations in Google Sheets, ClickUp, Monday, Wrike, SmartSheet, Notion, and Coda
Share
Explore

icon picker
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

All Tasks
2
Task Name
Dependency
Duration
Team
Owner
Task Start Date
Task End Date
Dep Start Date
Dep End Date
1
Instructor Shoot
5 days
Creative
Felix Marlin
10/1/20
10/6/20
2
GTM planning kicked off
Instructor Shoot
1 day
Marketing
Buck Dubois
10/6/20
10/7/20
10/1/20
10/6/20
3
Portraiture photography selected
Instructor Shoot
2 days
Marketing
Joel Davis
10/6/20
10/8/20
10/1/20
10/6/20
4
Class editing
Instructor Shoot
3 days
Engineering
Lola Tseudonym
10/6/20
10/9/20
10/1/20
10/6/20
5
Complete class trailer
Class editing
3 days
Creative
Polly Rose
10/9/20
10/12/20
10/6/20
10/9/20
6
Complete class workbook
Class editing
5 days
Creative
Mary Jones
10/9/20
10/14/20
10/6/20
10/9/20
7
Class finishing
Class editing
4 days
Marketing
Buck Dubois
10/9/20
10/13/20
10/6/20
10/9/20
8
Test class on site
Class finishing
1 day
Marketing
Alan Chowansky
10/13/20
10/14/20
10/9/20
10/13/20
9
Site copy
GTM planning kicked off
2 days
Creative
Polly Rose
10/7/20
10/9/20
10/6/20
10/7/20
10
Social media posts prepared
GTM planning kicked off
1 day
Engineering
James Booth
10/7/20
10/8/20
10/6/20
10/7/20
11
Class branding finalized
Site copy
1 day
Marketing
Alan Chowansky
10/9/20
10/10/20
10/7/20
10/9/20
12
Engineering sign off
Test class on site
3 days
Engineering
Felix Marlin
10/14/20
10/17/20
10/13/20
10/14/20
13
Launch 🚀
Test class on site
2 days
Engineering
James Booth
10/14/20
10/16/20
10/13/20
10/14/20
14
Promote on social media
Launch 🚀
1 day
Marketing
Polly Rose
10/16/20
10/17/20
10/14/20
10/16/20
There are no rows in this table

Gantt chart of All Tasks
2
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
Oct 2023
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 2023
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 2023
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 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
Feb 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
Mar 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
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
Month
TodayFit

Calendar view of All Tasks
2

March 2024

Month
Today
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.