Portfolio Management

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…

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.

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.…

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…

Hello Smartsheet Community - I am looking for work and I wanted to put my credentials out there just in case someone in our community knows someone who knows someone who needs someone. 🙂 Thanks in advance. Be safe, be smart! ~Yvonne

I am currently using the following INDEX/MATCH formula to return values from the sheet labeled "Tech Project List" in the reference. =INDEX({Summary from Tech Project List}, MATCH([Tech List Row ID]@row, {Project ID from Tech Project List}, 0)) I now want to expand that formula to include a condition: If #NO MATCH on Tech…

Hi everyone, I wanted to share some insights on how we’ve been using Smartsheet to tackle some of the most common challenges in change management. Whether you’re dealing with leadership alignment, struggling to keep projects on track, or facing difficulty engaging teams during a change process, I’ve found that having a…

My team manages many projects, each having a sheet with many parent and child tasks. I am researching ways to roll project data up into overall portfolio views for leadership but all of the PPM/PPO templates Smartsheet provides seem to pull portfolio data from an "intake sheet" which is not a process we employ. I'm finding…

I'm using the Simple Project Portfolio template. I messed up one of the formulas on the Portfolio Metrics sheet, and now my dashboard and intake is messed up. How do I fix this?

Hello- I am trying to create an executive view for our portfolio that highlights the Project owner, status, summary, and then active issues, risks and changes. Mock up: I have created summary fields within the project plan, QRAIDD log and change log in order to get the count like my mock up above and am creating a summary…