Portfolio Operations Overhaul

The Problem

A cross-functional team managing 40+ projects had no consistent way to track status, priorities kept shifting without visibility, and leadership spent hours each week assembling manual reports.

Every Monday started with the same frustrating ritual: project managers scrambling to update spreadsheets, team leads chasing status updates through Slack, and executives waiting for a consolidated view that was already outdated by the time it arrived.

The Constraints

• Could not replace the existing tooling (Smartsheet) due to org-wide license
• Team was skeptical of "yet another process change"
• Limited budget for new tools or extensive training programs
• Leadership needed improvements within 8 weeks

The organization had already invested significantly in Smartsheet, and the contract was locked in for another two years. Any solution had to work within this constraint rather than around it.

What We Did

Phase 1: Discovery and Mapping

We started by mapping existing workflows and shadowing team members during their daily routines. This revealed three critical breakpoints in handoffs:

1. Intake chaos: New requests came through email, Slack, and verbal asks with no centralized tracking
2. Status black hole: Project updates lived in individual project sheets with no rollup
3. Manual reporting: Leadership reports were assembled by copying data from 12+ sources

Phase 2: Standardized Intake

We built a standardized intake form with auto-routing based on project type and priority. The form:

• Captures all required information upfront
• Automatically assigns to the right team based on criteria
• Creates the project structure from templates
• Notifies stakeholders immediately

Phase 3: Rollup Dashboards

Rather than asking people to update a separate status tracker, we created rollup dashboards that pulled directly from project sheets. This meant:

• No duplicate data entry
• Real-time visibility for leadership
• Automatic flag when projects went off-track

Phase 4: Training and Adoption

We ran 3 focused training sessions with follow-up office hours:

1. Session 1: The new intake process (30 min)
2. Session 2: Dashboard navigation for leadership (30 min)
3. Session 3: Advanced tips and Q&A (45 min)

Office hours ran for 4 weeks after launch to address questions in real-time.

The Result

Reduced status meeting time by 60%. Leadership now has real-time visibility without asking. Team adoption hit 90% within 6 weeks.

The weekly status meeting went from 90 minutes of report-outs to 35 minutes of actual decision-making. Project managers reclaimed an average of 4 hours per week previously spent on manual reporting.

"For the first time, I can see the whole portfolio without asking anyone. The team actually trusts the data because they own it." — VP of Operations

Tools Used

• Smartsheet
• Slack
• Confluence

Key Takeaways

1. Work within constraints: The best solution isn't always new tooling—sometimes it's better configuration of what you have
2. Reduce friction, don't add it: Rollups beat manual updates every time
3. Train for adoption, not just features: Office hours were crucial for building confidence
4. Quick wins build trust: Shipping the intake form first gave the team an early win that built momentum