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 …
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 templ…
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 …
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 …
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 ad…
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]@r…
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, str…
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 te…
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 w…