-
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…
-
Best Way to Facilitate Task Hand-Off to Different Assignees
I've been trying to build out a solid "template" of sorts to help manage numerous tasks/subtasks for similar but different projects. Each row contains a parent task or a child task (subtask). Many of these tasks change hands throughout the process of the project as it evolves toward completion. As one example, Assignee A…
-
Unique ID auto generated from State designation
I have attached an image of a project schedule. I need to generate a formula for the "task-id" column that auto-generates a unique prefix and suffix based on the "state" column. The formula should reference the two character state and and start at 0001, if this initial encounter of that state. If the state has been…
-
PMO Template-- Archiving Projects
I have begun setting up/ using the PMO template. I am wondering if there is a way to archive old, completed projects so my project-level folder stays organized but the data is still available. Thanks
-
How do you track small contractor jobs within larger project plans?
Hi everyone, I’ve been building out a few project plans in Smartsheet for some upcoming property updates, and one thing I’m not sure how to handle cleanly is tracking small, independent contractor work like when we bring in a concrete contractor or a local crew for a quick 2-3 day job. These smaller jobs aren’t full…
-
Dashboard - How to Add Dynamic Editable Text on Dashboards
Hi, I am working on creating a Dashboard where the Project Manager (PM) can input their Project Summary, which will then be displayed on their Dashboard. I understand that I can create a Metric Widget, connect it to a specific sheet, and point it to a particular cell. However, I need to ensure that this setup remains…
-
Do Not Email Notify Triggering User from Workflow Automation (PMO)
How can I stop my automations from copying the triggering user via email? The automation itself works great for letting the inteded person know they've had a task row assigned to them via email - but the triggering user does not want to be copied on said notification. I've searched the community for answers - I've been…
-
How do I automate the creation of a project schedule from a form submission?
Hoping someone might be able to help me figure out this workflow: Form is submitted requesting a new project with the following information: name of project, requested go live date, assigned project manager This form submission triggers a workflow that will automatically pull a project template, inserts "name of project"…
-
Create a what if scenario using a late start date
I am working with a project timeline with dependencies. I have set up 2 additional date columns for late start and late finish where the late finish date is a formula for late start @row + duration. How can I set this up to calculate all the dependent late dates for start and finish? For example, I have several activities…
-
Multiple Project Tracker
Hello! I'm looking for the best way to track multiple projects across my company and also be able to give a high-level dashboard view to my executives. Which template would work best for this? I liked the Project Management Office, but we don't need an intake form as I would be the only one updating and adding new projects…
-
PMO within a PMO - creating sub-projects for one existing project
I have an extensive PMO setup and working well. I need to create a sub-project within an existing project. The idea is to track sites that are associated with a project. Is there a best practice for this? There will be about 100 sites that need their own project plan, dashboard, etc., and should roll up to the primary…
