Challenge
A premium advertising agency’s PMO was managing a large portfolio of projects across 15+ project managers using separate Smartsheet plans with little centralized operational visibility. Resource allocation, timelines, and project status tracking were fragmented across isolated files, making it difficult to identify delivery risks or resource conflicts across shared creative teams.
Project managers were spending recurring coordination meetings manually reviewing schedules to uncover conflicts, while executives relied on repetitive status emails and manually assembled reporting decks that provided limited real-time visibility into the portfolio.
Insight
The organization already had most of the project data it needed, but inconsistent project structures prevented the PMO from using that information effectively at a portfolio level. Because project plans were formatted differently and managed independently, reporting and resource tracking required constant manual coordination.
Standardizing how project data was captured would make it possible to aggregate reporting dynamically, surface resource conflicts earlier, and create a centralized operational view across the PMO without changing how teams managed their projects day to day.
Solution
Standardized Smartsheet project templates across the PMO so project data could be aggregated consistently across all active plans. Structured resource allocation tracking was added directly into project schedules, allowing teams to assign resources and estimated effort percentages without introducing separate reporting workflows.
A centralized reporting process was then built to aggregate project and resource data into a Google-based dashboard application. The dashboard provided portfolio-level Gantt views, resource conflict visibility, milestone tracking, escalation reporting, project summaries, and links to supporting documentation. Searchable project reporting replaced repetitive status emails and manually assembled presentation decks with a more dynamic operational reporting system.
Results
The new workflow replaced manual status aggregation and repetitive PMO coordination reviews with centralized portfolio reporting and real-time operational visibility. Project managers gained a more efficient way to identify resource conflicts, manage delivery risk, and coordinate across shared teams without adding additional administrative overhead.
Executives gained direct access to current project status, timelines, risks, escalation notes, and supporting documentation through a centralized reporting interface rather than relying on static updates and manually prepared presentations. The PMO improved portfolio visibility, streamlined communication, and shifted recurring coordination efforts toward more strategic operational discussions.