-
Project Schedule Baseline - Is History Kept when Re-baselined?
We are using the Project Schedule Baseline functionality, but recently learned that the Schedule can be Reset or Removed. Is there anyway to track how many times a Schedule has been 'Reset' or 'Removed' and baselined again? Our concern is that without the history being tracked on how many times it's been reset, we won't…
-
Packing Slip Template Final
Hi, I am currently on this page and have downloaded the Packing Slip Template. I have opened it in smartsheet, but cannot find out how to make it look like the Final Draft that this page shows. Am I missing some feature?
-
Do Smartsheet Support an API to fetch header names of a template?
I want to make an API call to fetch the column names and respective datatypes of a user-created-templates.
-
How do I get formulas from a sheet pointing to a template to work when the template is saved as new?
I've got a template built for a repeating project format and I want to be able to roll up key fields from all of the projects into some combined sheets. The formulas work when populating the original project sheet but when I save as a new sheet, the link breaks. This is only a problem in breaking the links going from the…
-
Is it possible to automate link creation between 2 smarthsheets?
Regarding the question above, consider a scenario where 1 project requires 2 linked smartsheets. Now consider a scenario where 50+ projects each require 2 linked smartsheets and a new project is added to the que 2 or 3 times a week. Is it possible to have two "master" smartsheets linked to each other that can be copied and…
-
Formula to Roll Up Task Status
Hi All! I am looking for some help with a formula that I haven't been able to find in the community already. I'd like to roll up my Status column to the parent rows with the following conditions: Parent shows as Not Started if: All children are either Cancelled or Not Started. Parent shows as In Progress if: Even one child…
-
Can I make a template with sheets I already have?
I have been looking into saving my sheets as templates, and I think this would be a great option for our uses, but the problem is that all of my sheets for this year have been created. Each year I have 8+ large sheets with the same structure, and throughout the year we make some changes to formulas, add columns, etc. Right…
-
Building a Q&A sheet
Are there any templates for building an FAQ database?