-
Welcome to the Project Management Office (PMO) Community!
This is a space for Smartsheet users that work in Project Management Office (PMO) functions to connect, share ideas, challenges, best practices and how you are using Smartsheet to transform your specific use case. Our Smartsheet team will be sharing helpful resources, upcoming industry events, discussion questions, and…
-
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…
-
Does anyone have a project plan used to bring Smartsheet into your company?
Looking for a project plan that I could use to bring Smartsheet into my company. We are going to be needing SSO Control Center Building Templates for Control Center Building out connectors (mainly for Azure DevOps) Creating Reports (for projects but also for users to see open tasks by project assigned to them) anything…
-
Assistance on Calculating Target % Complete & Understand %Complete calculation
I need assistance with understanding how the % Complete for parent tasks in Smartsheet. Specifically, I’m trying to understand how Smartsheet computes these percentages at higher hierarchy levels when using formulas. Even though the Actual%Complete and my calculate column of "Developed %" values for child tasks are…
-
Dashboarding Annual Calendar: Best Practice
Trying to develop a calendar/dashboard to reflect the major milestones of all projects happening in the PMO and having a difficult time! I haven't been able to find a dashboard visualization that easily displays all projects at a high level with callouts for project milestones.. I tried a timeline widget (see image below)…
-
Several Master Sheets vs Just One
Hi Smartsheet community, I would kindly ask for your best practices/recommendations to handle the following situation in a large company where we are using the PMO Template for managing IT Projects. When we built the solution, we started with two main files: DataSource → List of demands and details, sourced from our…
-
Use Cases for Smartsheet Bridge or AWM
Hi Everyone, I've been working to bring my PMO into Smartsheet for our documentation over the past 18 months. My team has made a lot of progress with using sheets to track assignments, out of office time, and the progress of change orders, but we're starting to run into some roadblocks when it comes to scaling our…
-
Board View card order
We're running sprints every 2 weeks and have a lot of cards in each lane in Board view. I manually set each card in a particular order from top to bottom in each lane since there is no current Sort option. Randomly, Smartsheet will re-order the cards! I can't figure out why they are getting re-ordered, what is causing it,…
-
Introduction
Hi all, my name is Vesna and I work as a senior project manager in regulatory affairs for medicines. I am so excited to use the Smartsheet!
-
Generation of a Project Management tool/tracker
Please could I have some advice before tackling the creation of a tracker. I need to create a sheet which tracks the progress of multiple documents which need reviewing by various departments. Ideally, the tracker would show the outstanding actions for each material and the status/work flow of the material is unable to…
-
One Project - 200+ clients same project: Dashboards for both?
I have 200 clients at different stages of the same project (or with up to 5 set-in-stone subprojects). I am a Filemaker Pro developer and could create this in FMPro, but why would I? Which template set is best? My SharePoint tracks time sheets and effort so I don't need to do that in Smartsheet, but want a Gantt chart to…