IC-Multiple-Project-Dashboard-Tracking-Template_Google-sheet

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1

2	MULTIPLE PROJECT DASHBOARD TRACKING TEMPLATE						https://www.smartsheet.com/try-it?trp=11362&utm_source=integrated+content&utm_campaign=/content/multiple-project-dashboards-templates&utm_medium=Multiple+Project+Dashboard+Tracking+google+sheets+11362&lpa=Multiple+Project+Dashboard+Tracking+google+sheets+11362&lx=PFpZZjisDNTS-Ddigi3MyABAgeTPLDIL8TQRu558b7w				https://www.smartsheet.com/try-it?trp=11362&utm_source=integrated+content&utm_campaign=/content/multiple-project-dashboards-templates&utm_medium=Multiple+Project+Dashboard+Tracking+google+sheets+11362&lpa=Multiple+Project+Dashboard+Tracking+google+sheets+11362&lx=PFpZZjisDNTS-Ddigi3MyABAgeTPLDIL8TQRu558b7w
3	DELIVERY TIMELINE & RESOURCES
4
5
6
7	PROJECT FINANCIALS
8
9
10	RISK ANALYSIS
11
12
13
14
15	OPEN & PENDING ACTIONS
16
17
18
19
20	PROJECT REPORT
21
22	PROJECT NAME	SCHEDULE	BUDGET	RESOURCES	RISKS	ISSUES	COMMENTS
23	Project A
24	Project B
25	Project C
26	Project D
27	Project E
28	Project F
29	Project G
30	Project H
31	Project J
32	Project K
33	Project L
34	Project M
35	Project N
36	Project P
37
38	DASHBOARD DATA
39	PROJECT NAME	TIMELINE				NUMBER OF TEAM MEMBERS	BUDGET			RISKS			OPEN		PENDING ACTIONS
40	PROJECT NAME	CALENDAR	BEGIN	FINISH	# of DAYS	NUMBER OF TEAM MEMBERS	PROJECTED	ACTUAL	REMAINDER	HIGH	MEDIUM	LOW	ISSUES	REVISIONS	PENDING ACTIONS
41	Project A	05/01/25	05/05/25	07/01/25	57	10	$1,000,000	$880,000	$120,000	1	0	4	2	0	4
42	Project B	06/01/25	05/10/25	08/10/25	92	5	$900,000	$920,000	-$20,000	2	3	5	1	2	3
43	Project C	07/01/25	06/10/25	03/01/26	264	10	$860,000	$850,000	$10,000	3	4	3	2	1	2
44	Project D	08/01/25	06/22/25	08/04/25	43	5	$1,000,000	$998,050	$1,950	5	8	1	1	0	0
45	Project E	09/01/25	07/14/25	11/01/25	110	10	$294,000	$280,000	$14,000	8	6	4	0	3	1
46	Project F	10/01/25	07/14/25	01/20/26	190	5	$123,400	$125,000	-$1,600	5	0	0	2	0	2
47	Project G	11/01/25	08/01/25	10/01/25	61	10	$250,500	$246,000	$4,500	6	4	0	1	2	3
48	Project H	12/01/25	08/14/25	08/30/25	16	5	$127,200	$126,000	$1,200	7	3	3	0	1	4
49	Project J	01/01/26	09/01/25	12/10/25	100	10	$80,000	$79,900	$100	0	2	4	1	3	2
50	Project K	02/01/26	10/01/25	11/15/25	45	5	$77,000	$77,000	$0	4	4	5	2	0	0
51	Project L	03/01/26	10/01/25	12/01/25	61	10	$65,000	$65,000	$0	3	6	4	3	2	0
52	Project M	04/01/26	11/01/25	12/01/25	30	5	$550,000	$551,000	-$1,000	2	3	6	0	1	1
53	Project N	05/01/26	11/10/25	12/10/25	30	10	$45,000	$42,000	$3,000	1	1	7	1	0	2
54	Project P	06/01/26	12/01/25	02/10/26	71	5	$32,500	$33,000	-$500	5	0	2	2	1	3
55							$5,404,600	$5,272,950	$131,650	52	44	48	18	16	27
56
57	CLICK HERE TO CREATE IN SMARTSHEET
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