Project Tracking Template Google Sheet

	B	C	D	E	F	G	H	I	J	K	L	M	N	P	R
1
2	PROJECT TRACKING TEMPLATE										https://goo.gl/UTlQLz
3											https://goo.gl/UTlQLz
4		PROJECT DETAILS							DELIVERABLES		COST/HOURS			STATUS KEY	PRIORITY KEY
5	STATUS	PRIORITY	START DATE	END DATE	DURATION	TASK NAME	ASSIGNEE	DESCRIPTION	DELIVERABLE	% DONE	FIXED COST	ESTIMATED HOURS	ACTUAL HOURS	On Hold	Low
6	Project Name									46%	$1,640.00	55	56	Not Yet Started	Medium
7	On Hold	High	9/9/18	9/10/18	1	Task		details of task here		100%	$200.00	30	25	In Progress	High
8	Not Yet Started	Low	9/10/18	9/14/18	4	Task				50%	$600.00	11	10	Complete
9	In Progress	Medium	9/11/18	9/20/18	9	Task				22%	$800.00	12	18
10	Complete	Medium	9/12/18	9/20/18	8	Task				11%	$40.00	2	3
11	Project Name									3%	$0.00
12					0					11%	$0.00
13					0					0%	$0.00
14					0					0%	$0.00
15					0					0%	$0.00
16	Project Name									0%	$0.00
17					0					0%	$0.00
18					0					0%	$0.00
19					0					0%	$0.00
20					0					0%	$0.00
21	Project Name									0%	$0.00
22					0					0%	$0.00
23					0					0%	$0.00
24					0					0%	$0.00
25					0					0%	$0.00
26	Project Name									0%	$0.00
27					0					0%	$0.00
28					0					0%	$0.00
29					0					0%	$0.00
30					0					0%	$0.00
31
32	CLICK HERE TO CREATE PROJECT TRACKING TEMPLATES IN SMARTSHEET
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier! Saves Data!