-
Program Management within PMO structure
I need to set up a Program (Multiple projects). What is the best way to do this within my portfolio? Set up each project in the program as a separate projects? add these projects as separate sections within one project plan? Ultimate goal is the have a status for the program and have the program report as a status in the…
-
Program Toolkit: How to rename program through control panel & Keep existing cell links.
I have several program folders with smartsheet templates connected to a blueprint, managed by Control Center. My question is this; How do I change the program name of a folder and its sheets while retaining all existing cell links? Additionally these programs roll up into other sheets for reporting and dashboards, These…
-
Portfolio Template with Capacity Waterline Help
I'm thinking of transitioning my current project portfolio to this template that includes a capacity waterline but I'm having trouble getting started. Usually the templates include a guide on where to start and how the data flows between the sheets, reports, and dashboards but I can't find it for this one. Thanks in…
-
Simplified Visual Portfolio View
Hello, I am currently using the Project Management Office Template. I have many many projects in here. I am having trouble visualizing the Gannt charts when trying to pull in a lot of projects and compare. I'd like to get something very simple like this: I need to be able to see: How many projects I need to close per month…
-
How can I automate dashboard charts?
Hi everyone, I'm fairly new to Smartsheet and looking for some advice. I'm in the process of building a project portfolio dashboard and would like to automate a 'Workload Distribution' chart. Currently, I have to manually update a separate metric sheet that serves as the data source, however, with how frequently the data…
-
Portfolio Updates to Leadership
Hello, I'm exploring ways to enhance how our team shares portfolio updates with leadership. Currently, we rely on PowerPoint presentations with screenshots from SS or direct snapshots of our dashboard. I'd appreciate any suggestions on how we can make these updates more elegant, insightful, and impactful.
-
Creating a portfolio level RAID log
I'm wondering how others have used Smartsheet to create a portfolio view of risks and issues. We aren't a large organisation and there is a lot of interdependence between different projects. It feels like overkill to create a separate RAID log for every project. I'm thinking about adding a column to the RAID log that will…
-
Formula for Cross-Sheet References Based on Row/Task Information
Is there a way [in the Core App - without Control Center] to create a formula that pulls in data from another sheet via cell linking, but is set up in a way that it can be used in a repeated use template? To give an example of what I'm trying to do: I have a set of projects that are fairly consistent as far as activities.…
-
Suggestions for Risk Register Reporting
We have created a blueprint for all projects to have the same workspace within Smartsheet. Part of this includes a mandatory Risk Register that all projects are required to update monthly. I'm in the process of creating portfolio reporting for my leadership team that includes an overarching dashboard and some separate…