-
Automation in Template not Working
I have a template that has an automation that moves rows at a certain time of day to another sheet. When certain users create a sheet using the template the automation is unable to run. with the error "unknown destination". I need some help. Do all users need access to the destination sheet as well? I want to avoid that.
-
Form URLs should automatically update on newly saved dashboards when copying a workspace template
As a user, I would like form URLs to automatically update on newly saved dashboards when copying a workspace, So that I do not have to manually update the Form URLs and prevent the risk of forms accidentally pointing to the original sheet or workspace. Please refer to case # 05972330, as this had been previously assumed to…
-
Idex/Match is refusing to match against any "Project ID" that does not start with "SM"
I cannot for the life of me figure out why an Index/Match between a project Metadata Sheet and the project Intake Sheet refuses to find any matches unless the Project ID has "SM" in it. This was originally the "Project Management Office" template from Smartsheet, but has since been revised. My formula on the Metadata sheet…
-
Do I really have to make the same change on every single one of my sheets separately?
Hi Folks - I'm pretty much a newbie to SS, but I have already created 20+ different sheets for each of my projects, using a template. Now, if I want to make a change to the structure of all the sheets (ie, change the name of a column, add an alert, or anything really!)… is there not a way to automatically make the same…
-
"Live" source template sheet
We have projects running with long and complex workflows and thousands of tasks - so we need to break these down into multiple sheets (dozens), and then use reports to extract data from tasklits to time-tracking and budget burndown. However - if we need to change the structure or components of the sheet in any way ( extra…
-
Can I use global update on a sheet template's form?
I would like to do a Global Update in Control Center on a sheet template's form. This will allow me to update the form on a specific sheet in 70+ projects very efficiently. My worry is that this functionality is not available and instead I will need to go into each project, find the specific sheet, and manually update the…
-
Control Centre - Adding an Optional Template to a provision Project.
I am attempting to add a new optional template sheet to a provisioned Project via Control Centre. When the new optional template sheet is added to the Project, the references, and some cell links are broken. Is it possible to add an optional template to a Control Centre provisioned project and have the references and links…
-
Access to a template in a workspace
I have created a template and saved it in a workspace. For some reason, the collaborators shared to the workspace (editor-can share access) are not able to see the template. Is this expected behavior?
-
Template sharing within the community!
Love the community building, better yet when one of us has made a great work product, turn it into a template and share it. Make a community template library! Include owner's contact information should someone have a question. Then when someone takes it and makes it even better, share it again! Hyper-Collaboration!
-
Templated Sheets and Dashboards
Hello! I have been trying to do some research into this and all of the previous questioned posted were all from some time ago (3,4 years!) so I wanted to revisit the question. I am working on a means to create a templated sheet that is automatically tied to a dashboard that does not require someone to manually switch the…