IC-Construction-Project-Dashboard-Template_Google_Sheets

	B	C	D	E	F	G	H	I
1

2	Construction Project Dashboard Template Example				https://www.smartsheet.com/try-it?trp=12328&utm_source=template-google-sheet&utm_medium=content&utm_campaign=Construction+Project+Dashboard-google-sheet-12328&lpa=Construction+Project+Dashboard+google-sheet+12328
3	Project Name				Date	Project Status	% Complete
4	Project Alpha				MM/DD/YY	In Progress	72%
5	Task Timeline
6
7
8
9	Dashboard Data
10	Task Table
11	Task Name	Assigned To	Start Date	End Date	Duration in days	Status	Priority	Comments
12	Demo Prep	Alex B.	01/02	01/08	6	Complete	Low
13	Demolition	Frank C.	01/04	01/11	7	Complete	Medium
14	Excavation	Jacob S.	01/07	01/11	4	Complete	High
15	Concrete	Jacob S.	01/10	01/15	5	Complete	Low
16	Pre backfill	Jacob S.	01/13	01/20	7	Complete	Medium
17	Framing	Alex B.	01/16	01/29	13	Overdue	Low
18	Roof	Frank C.	01/19	02/01	13	In Progress	Low
19	Plumbing	Kennedy K.	01/22	02/09	18	In Progress	Medium
20	Windows	Jacob S.	01/25	02/05	11	In Progress	Medium
21	HVAC	Alex B.	01/28	02/06	9	On Hold	High
22	Electrical	Kennedy K.	01/31	02/02	2	Not Started	High
23	Launch	Donald W.	02/03	02/04	1	Not Started	High
24
25	Task Status %				Budget
26	STATUS	COUNT	%		PLANNED	80,000
27	Not Started	2	17%		ACTUAL	50,000
28	In Progress	3	25%
29	Complete	5	42%
30	Overdue	1	8%
31	On Hold	1	8%
32	TOTAL	12	100%
33
34	TASK PRIORITY %				PENDING ITEMS
35	PRIORITY	COUNT	%		Decisions	5
36	High	4	33%		Actions	2
37	Medium	4	33%		Change Requests	4
38	Low	4	33%
39		0	0%
40	TOTAL	12	100%
41
42	CLICK HERE TO CREATE IN SMARTSHEET
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