IC-Project-Management-KPI-Dashboard-Template_Google_Sheets

	B	C	D	E	F	G	H	I	J
1

2	PROJECT MANAGEMENT KPI DASHBOARD TEMPLATE							https://www.smartsheet.com/try-it?trp=11613&utm_source=integrated-content&utm_campaign=/content/kpi-dashboard-templates&utm_medium=Project+Management+KPI+Dashboard+google+sheets+11613&lpa=Project+Management+KPI+Dashboard+google+sheets+11613
3	PROJECT NAME				DATE	PROJECT STATUS	% COMPLETE
4	PROJECT ALPHA				MM/DD/YY	ON TRACK	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	RISK	PRIORITY	COMMENTS
12	Set Kick-Off Meeting	Alex B.	01/02	01/08	6	Complete	Low	Medium
13	Agree on objectives	Frank C.	01/04	01/11	7	In Progress	Medium	Low
14	Detail requests	Jacob S.	01/07	01/11	4	Overdue	High	High
15	Hardware requests	Jacob S.	01/10	01/15	5	Complete	Low	Medium
16	Final resource plan	Jacob S.	01/13	01/20	7	Complete	Medium	Medium
17	Staffing	Alex B.	01/16	01/29	13	Not Started	Low	Medium
18	Technical requests	Frank C.	01/19	02/01	13	Not Started	Low	Low
19	Training	Kennedy K.	01/22	02/09	18	In Progress	Medium	High
20	Testing	Jacob S.	01/25	02/05	11	Overdue	Medium	Low
21	Dev. Complete	Alex B.	01/28	02/06	9	Not Started	High	High
22	Hardware configuration	Kennedy K.	01/31	02/02	2	Complete	High	High
23	System testing	Donald W.	02/03	02/04	1	Complete	High	High
24
25	TASK STATUS %				BUDGET
26	STATUS	COUNT	%		PLANNED	80,000
27	Not Started	3	25%		ACTUAL	50,000
28	In Progress	2	17%
29	Complete	5	42%
30	Overdue	2	17%
31	On Hold	0	0%
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