-
Ability to update Smartsheet Templates with Non-Working Days to support year-over-year changes
Smartsheet grants Admins the ability to update global settings such as Non-working days however, this setting only applies to new sheets so, if your organization heavily depends on Templates, the settings for non-working days does not apply. Our organization has over 50 reusable templates and some dating back to 2019…
-
Is it expected behavior for "Blueprint Summary" Cell Links from an "Optional" template not to work?
Using Control Center, I am adding an "optional" sheet from the blueprint templates to some existing projects. While Control Center is then linking the identified "Blueprint Summary" fields from the newly added sheet to our metrics Rollup sheet….they don't actually function. Meaning they show a blue arrow as if they are…
-
Smartsheet Formula of The Week!
Hey Smartsheet Community! We're excited to introduce our DigitalRadius' Formula of the Week Email! Each week, we’ll share a practical Smartsheet formula to help streamline workflows and solve real-world challenges—all for free! This week’s formula: Flag duplicate values in a column to clean up your data and avoid errors.…
-
Adapting an Existing Formula
Hi, I would like to adjust the formula that comes with the Project Management Office Templates. The Smartsheets template comes with this formula in the "Portfolio Metrics" sheets in the Total column and on the In Progress row. =COUNT(COLLECT({Project ID}, {Project Status}, $Label@row)). I would like to change Project ID to…
-
BC/DR Planning
Hi - Does Smartsheet have any template sets to create dynamic business continuity/disaster recovery plans (call trees, system diagrams, etc.)? Thanks in advance!
-
Issues with Numbering Children (Child 1, Child 2, etc.)
Hi! I am trying to implement a column formula in Smartsheet that assigns an ordinal number to each of the children in a sheet. For example, the first child would get a "1", the second child a "2", and so on. I've tried several options, and the one I liked the most is the following: Create an auxiliary column with a "1"…
-
Adding additional rows to PMO a Project Metadata Sheet + Project Category ideas
Hello! Has anyone ever added multiple Project ID rows to a PMO Project Metadata sheet? Each one of our projects will have 7 component ('project') plans so I would like to have those included on the project metadata sheet. I did a test and added each component to the Intake sheet and then copied/pasted the first row on the…
-
Project template sets - weighing options
Hello, all! What's the benefit in using the PMO template set over the Project Tracking & Rollup set or the Construction & Facilities/Multi Project set? In looking at each, and playing around with the PMO set, it seems like it might be more robust than what we need. We have multiple clients, some with multiple projects.…
-
Target Date vs Baseline in Project Management Office template
The project plan in PMO template have Target Start Date and Target End Date which seem to serve the same purpose as the Baseline Start and Baseline Finish. Are they redundant or am i missing something?
-
templates
I recently created a project from the templates provided - the 'Ticketing system' one. How would I go about changing the 'duration' column from days to hours? We report on an hourly basis for our projects but it's a locked field and when I edit it, it doesn't give me the option to change the type. Thanks in advance!