ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAM
1
2
Agile Project Portfolio Dashboard Templatehttps://www.smartsheet.com/try-it?trp=12221&utm_source=template-google-sheet&utm_medium=content&utm_campaign=Agile+Project+Portfolio+Dashboard-google-sheet-12221&lpa=Agile+Project+Portfolio+Dashboard+google-sheet+12221
3
Enter project data below; charts, graphs, and summary info will populate automatically.
4
This tab contains example data. To begin building your dashboard, use the BLANK tab. If necessary, enter alternate dropdown menu data in the tables below.
5
DepartmentDepartment LeadDate of Last Update
6
MarketingMarta Hicks10/21/20XX
7
8
Portfolio Progress
Portfolio Financial Health
9
Deliverables75Bugs26Total Planned Budget$5,961,000
10
% Finished31%Stories27Total Actual Spend$5,865,500
11
% Ongoing21%Tasks22Budget Utilization Rate98%
12
13
Deliverables by Priority
Deliverables by Status
Priority Level
Risk Radar
14
15
16
Project Data
17
Deliverable TypeIDDescriptionPriorityStatusAssigned ToBudget PlannedBudget ActualBudget RemainingExpected Start DateExpected Date of CompletionDuration in DaysNumber of Days RemainingPercent of Project CompleteRisk LevelAssociated RisksCommentsAttachments / Links
18
BugHighFinished $ 525,000 $ 500,000 $ 25,000 03/05/2412/30/24301(260)100%Highly Unlikely
19
StoryMediumOverdue $ 285,000 $ 312,000 $ (27,000)04/16/2409/14/24152(367)90%Unlikely
20
TaskHighOverdue $ 430,000 $ 384,000 $ 46,000 08/25/2409/30/2437(351)50%Possible
21
BugLowOverdue $ 85,000 $ 132,000 $ (47,000)09/10/2411/25/2477(295)85%Likely
22
StoryMediumPaused $ 250,000 $ 288,500 $ (38,500)–15%Highly Likely
23
BugLowFinished $ 45,000 $ 62,000 $ (17,000)–100%Highly Likely
24
BugHighProposed $ 580,000 $ 450,000 $ 130,000 –50%Unlikely
25
BugHighUnscheduled $ 785,000 $ 625,000 $ 160,000 –10%Highly Unlikely
26
TaskExtremeReview – –5%Unlikely
27
TaskExtremeApproved – –30%Unlikely
28
TaskExtremeOngoing – –45%Highly Unlikely
29
TaskLowFinished – –100%Unlikely
30
StoryLowPaused – –85%Unlikely
31
BugLowOverdue – –30%Unlikely
32
StoryLowTerminated – –0%Highly Unlikely
33
BugLowFinished – –100%Highly Unlikely
34
StoryLowFinished – –100%Unlikely
35
BugLowFinished – –100%Unlikely
36
StoryLowFinished – –100%Highly Unlikely
37
StoryMediumFinished – –100%Highly Likely
38
TaskMediumFinished – –100%Unlikely
39
TaskMediumFinished – –100%Highly Unlikely
40
StoryMediumFinished – –100%Highly Likely
41
BugMediumFinished – –100%Likely
42
BugExtremeFinished – –100%Likely
43
StoryHighFinished – –100%Likely
44
TaskHighFinished $ 500 $ 500 –100%Likely
45
TaskMediumOngoing – –35%Likely
46
BugHighFinished – –100%Likely
47
BugMediumFinished $ 65,000 $ 58,000 $ 7,000 –100%Highly Unlikely
48
BugLowOngoing $ 98,500 $ 125,000 $ (26,500)–50%Unlikely
49
StoryExtremeOngoing $ 280,000 $ 312,000 $ (32,000)–25%Likely
50
StoryLowOngoing $ 325,000 $ 343,000 $ (18,000)–25%Unlikely
51
TaskLowApproved $ 125,000 $ 123,500 $ 1,500 –13%Likely
52
StoryLowApproved $ 250,000 $ 239,500 $ 10,500 –28%Likely
53
BugLowOverdue – –25%Highly Unlikely
54
StoryLowPaused – –25%Unlikely
55
BugLowPaused – –30%Unlikely
56
StoryLowPaused – –10%Highly Unlikely
57
StoryHighNot Started – –5%Unlikely
58
TaskExtremeReview – –18%Unlikely
59
TaskExtremeApproved – –30%Unlikely
60
TaskExtremeOngoing – –25%Highly Unlikely
61
TaskLowFinished – –100%Unlikely
62
StoryLowPaused – –20%Unlikely
63
BugLowOverdue – –20%Unlikely
64
StoryLowTerminated – –20%Highly Unlikely
65
BugLowReview – –20%Highly Unlikely
66
StoryLowReview – –30%Unlikely
67
BugLowApproved – –40%Unlikely
68
StoryLowApproved – –50%Highly Unlikely
69
StoryMediumApproved – –60%Highly Likely
70
TaskMediumFinished – –100%Unlikely
71
TaskMediumFinished – –100%Highly Unlikely
72
StoryMediumOngoing – –25%Highly Likely
73
BugMediumOngoing – –30%Likely
74
BugExtremeOngoing – –40%Likely
75
StoryHighOngoing – –50%Likely
76
TaskHighOngoing $ 500 $ 500 –60%Likely
77
TaskMediumOngoing – –70%Likely
78
BugHighOngoing – –80%Likely
79
BugMediumFinished $ 65,000 $ 58,000 $ 7,000 –100%Highly Unlikely
80
BugLowOngoing $ 98,500 $ 125,000 $ (26,500)–50%Unlikely
81
StoryExtremeOngoing $ 280,000 $ 312,000 $ (32,000)–25%Likely
82
StoryLowOngoing $ 325,000 $ 343,000 $ (18,000)–25%Unlikely
83
TaskLowApproved $ 125,000 $ 123,500 $ 1,500 –13%Likely
84
StoryLowApproved $ 250,000 $ 239,500 $ 10,500 –28%Likely
85
TaskMediumFinished $ 84,000 $ 75,000 $ 9,000 –100%Possible
86
BugMediumNot Started $ 28,000 $ 27,000 $ 1,000 –0%Likely
87
BugLowTerminated $ 45,000 $ 45,000 $ - –0%Highly Unlikely
88
StoryHighNot Started $ 58,000 $ 58,000 $ - –0%Highly Unlikely
89
TaskExtremeUnscheduled $ 128,000 $ 133,000 $ (5,000)–5%Highly Unlikely
90
StoryHighUnscheduled $ 175,000 $ 184,000 $ (9,000)–5%Highly Unlikely
91
TaskHighFinished $ 58,000 $ 58,000 $ - –100%Highly Unlikely
92
BugExtremeNot Started $ 112,000 $ 130,000 $ (18,000)–0%Highly Unlikely
93
94
Dropdown Menu and Chart Data
95
If necessary, enter alternate dropdown menu data in the tables below.
96
Quantity columns calculate automatically to populate Dashboard charts; do not alter.
97
Deliverable TypeDeliverable
Quantity		Project
Status		Status
Quantity		Priority
Level		Priority
Quantity		Risk
Level		Risk
Quantity
98
Bug26Proposed1Low31Highly Unlikely22
99
Story27Unscheduled3Medium18Unlikely25
100
Task22Not Started4High14Possible2