.png)
.png)
Smartsheet Portfolio System
One source of truth for executives to track 30+ projects across 18 departments.
%20(1).jpg)
.jpg)
visibility
engine
From fragmented spreadsheets to unified executive visibility.
Challenge
The executive team couldn't answer basic portfolio questions without 2-3 days of manual data gathering:
• "What projects are at risk this quarter?"
• "Where are resources stretched thin?"
• "Which initiatives support our strategic goals?"
30+ projects were tracked in disconnected departmental spreadsheets. Email threads contained the latest status updates. Executive meetings became manual status report sessions instead of strategic decision-making.
There was no visibility across departments and no centralized reporting.
• "What projects are at risk this quarter?"
• "Where are resources stretched thin?"
• "Which initiatives support our strategic goals?"
30+ projects were tracked in disconnected departmental spreadsheets. Email threads contained the latest status updates. Executive meetings became manual status report sessions instead of strategic decision-making.
There was no visibility across departments and no centralized reporting.
Approach
As VP of the Project Management Office, I designed a layered Smartsheet portfolio system that included:
EXECUTIVE TIER
• Enterprise portfolio dashboard showing project health, risk, strategic alignment, and escalations on one screen
• One-click drill-down to project details
• Automated risk flagging based on schedule and resource thresholds
PROJECT TIER
• Standardized project templates with built-in RAID logs, milestones, and status tracking
• Automated status roll-ups to executive dashboard
• Cross-project dependency mapping
OPERATIONAL TIER
• Intake workflow that auto-classified Project vs. BAU work based on defined criteria
• Phase-gate approval framework with clear criteria
• Resource capacity views showing allocation across all active projects
TRAINING & SUSTAINABILITY
• 50-page PMO Operations Manual documenting the entire system
• PM team training on template usage and dashboard maintenance
• Quick-reference guides for intake, approvals, and escalations
EXECUTIVE TIER
• Enterprise portfolio dashboard showing project health, risk, strategic alignment, and escalations on one screen
• One-click drill-down to project details
• Automated risk flagging based on schedule and resource thresholds
PROJECT TIER
• Standardized project templates with built-in RAID logs, milestones, and status tracking
• Automated status roll-ups to executive dashboard
• Cross-project dependency mapping
OPERATIONAL TIER
• Intake workflow that auto-classified Project vs. BAU work based on defined criteria
• Phase-gate approval framework with clear criteria
• Resource capacity views showing allocation across all active projects
TRAINING & SUSTAINABILITY
• 50-page PMO Operations Manual documenting the entire system
• PM team training on template usage and dashboard maintenance
• Quick-reference guides for intake, approvals, and escalations
Outcome
✅ 30+ projects tracked in real-time across 18 departments
✅ 15+ hours/week save per project manager (previously spent on manual status compilation)
✅ 2-3 weeks earlier resource conflicts identified before they became critical
✅ 30 seconds leadership to answer "What's at risk?"
✅ Zero manual status reports needed for executive meetings
✅ 15+ hours/week save per project manager (previously spent on manual status compilation)
✅ 2-3 weeks earlier resource conflicts identified before they became critical
✅ 30 seconds leadership to answer "What's at risk?"
✅ Zero manual status reports needed for executive meetings
Long-Term Impact
ORGANIZATIONAL SHIFT:
Executive meetings moved from status updates to strategic portfolio decisions
Project approvals became data-driven
System scaled concurrent projects as organization grew
CULTURAL CHANGE:
Department heads gained visibility into cross-functional dependencies for the first time
PMO became trusted advisor instead of compliance function
Deliverables
SYSTEMS BUILT:
Executive and Risk portfolio dashboard (Smartsheet)12 standardized project templatesIntake and approval workflow automation
RAID tracking and escalation protocols
Resource capacity planning views
DOCUMENTATION:
50-page PMO Operations ManualVisual process maps for intake, approvals, and escalations
Quick-reference guides for all user types
Video training library for future onboarding
Executive meetings moved from status updates to strategic portfolio decisions
Project approvals became data-driven
System scaled concurrent projects as organization grew
CULTURAL CHANGE:
Department heads gained visibility into cross-functional dependencies for the first time
PMO became trusted advisor instead of compliance function
Deliverables
SYSTEMS BUILT:
Executive and Risk portfolio dashboard (Smartsheet)12 standardized project templatesIntake and approval workflow automation
RAID tracking and escalation protocols
Resource capacity planning views
DOCUMENTATION:
50-page PMO Operations ManualVisual process maps for intake, approvals, and escalations
Quick-reference guides for all user types
Video training library for future onboarding
Tools
• Smartsheet (portfolio system, dashboards, automation)
• Excel (initial data migration and analysis)
• SharePoint (document repository)
• PowerPoint (executive presentations)
• Microsoft Teams, Smartsheet University (training delivery)
• Excel (initial data migration and analysis)
• SharePoint (document repository)
• PowerPoint (executive presentations)
• Microsoft Teams, Smartsheet University (training delivery)
Proven delivery
framework
Every engagement follows a battle-tested approach:
→ Readiness audits to understand your current state
→ Custom-built systems in YOUR existing tools
→ Live handoff training ensures your team's full ownership
→ All deliverables become yours permanently
→ 30-day post-launch support via Slack/email
No junior consultants. No handoffs. Just VP-level delivery, personally.
→ Custom-built systems in YOUR existing tools
→ Live handoff training ensures your team's full ownership
→ All deliverables become yours permanently
→ 30-day post-launch support via Slack/email
No junior consultants. No handoffs. Just VP-level delivery, personally.