-
Capacity Planning Template
A google search shows me a capacity planning template exists in Smartsheet but I cannot seem to find it among the templates. I can see it via google search but when I go to download it I'm asked to create a Smartsheet account... but I already have one. Can anyone point me to the template within Smartsheet? Thank you
-
Best Template for Task
If my goal is to handle the overall progress of a number of projects, which template would be best to start with? It will be for the whole lifecycle - from application, setting meetings, follow up paperwork filled out and submitted, check ups, and request for final research results. It'll likely be laid out in a sequential…
-
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…