-
Do we have Test Management Template set ?
Hi All, I am quality analyst and work across different project which uses Project management template set. I can find individual template for Test Case, Test scenarios but need to manually link each project with Test Plan which is linked to Test Cases and Iterations. I have used Microsoft Test Manager, Atlassian Jira,…
-
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?