Smartsheet Portfolio System

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.

‍

‍

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

‍

‍

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

‍

‍

Testimonial

"Taylor's ability to bring structure, clarity, and momentum to large-scale initiatives was instrumental to our success. She helped implement standardized PM practices, executive steering, and precise reporting mechanisms, improving decision-making and accountability across the organization."

— Terry Phelps

Chief Operations Officer

Latino Community Credit Union

‍

‍

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 templates
• Intake and approval workflow automation
• RAID tracking and escalation protocols
• Resource capacity planning views

‍

DOCUMENTATION: 

• 50-page PMO Operations Manual
• Visual 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 (collaboration)
• Smartsheet University (training delivery)

‍

‍

WHAT THIS MEANS FOR YOUR ORGANIZATION

If your leadership is flying blind on 10+ active projects and asking "What's at risk?" triggers days of manual work:

→ Real-time portfolio visibility is achievable in weeks, not months — no massive tool overhaul required

→ Executive meetings can shift from status reporting to strategic decisions when data is automated

→ 15+ hours per week recovered per PM when status updates are no longer manual

‍

Book a discovery call to see what 30-second portfolio visibility looks like for your organization.

‍

‍

‍

‍

‍

‍

Some names, data, and organizational details have been altered or omitted to protect confidentiality. The structure and outcomes reflect a prior role as VP of the Project Management Office and now inform TL Consulting’s service offerings.