-
Is it possible to utilize a template in control center that generates new form url in that sheet?
Is it possible to utilize a template in control center that generates a new form url every time the project toolkit is provisioned? We are using a sheet (which is in this template) where the rows are populated via a form. If I use control center now it just overrides the template with every new project that's provisioned…
-
Control Center - Blueprint Permission setting for "Commenter"
We are able to set the sheet level permission "Commenter" for specific blueprint template, but we'd also like to be able to set up "Commenter" permission to certain User Group in Blueprint setting > Permission > Advanced. However, I only see these choices and no Commenter. Can you please add this choice so we don't have to…
-
Joining Data b/t an Intake Sheet & Summary Sheet
I am using Smartsheet control Center and have an Intake Sheet and a Summary sheet. I also have a Profile Data Sheet in my project template. The Intake & Summary sheets have a project # to join data. I'm wondering what is the best way to join data to display information on a report? 1 - Intake sheet populates a Project…
-
Multi-Select Projects to "Update Reporting" in Control Center
Whenever a change is made to a blueprint in control center we are already disadvantaged by only being able to apply this change to future projects created from the blueprint. We can however, using Global Updates retroactively add certain rows to summary sheets that can be a proxy to apply changes to existing projects.…
-
Solution Spotlight- New Employee/Provider Onboarding
Hello HLS Community! On Thursday July, 11th @ 10am PST our Solution Engineering team will be putting on a Solution Spotlight on how to optimize new employee/provider onboarding! You can register through this Smartsheet dashboard (no account required) There you will find the registration link, topics, resources, and…
-
Control Center Error message
Hi I am new to Control Center and I'm trying to do a global update to a formula. Here is the formula I want to change Current Formula: =IF(AND(YEAR(Created@row) = YEAR(TODAY()), MONTH(Created@row) = MONTH(TODAY())), 1) New Formula: =IF(AND(YEAR(Date@row) = YEAR(TODAY()), MONTH(Date@row) = MONTH(TODAY())), 1) Changing…
-
Control Center Malfunction
I recently tried to create a very basic folder of some template sheets via control center, which has worked really well in the past, but this time after "create project" this error message popped up: "Failed to get configuration sheet with sheet ID XXXXXXXXXX" Has anyone encountered this and if so how did you fix it? I…
-
Control Center Multi-Tier Auto-Provision
I'm looking to automate the provisioning of multi-tier projects in Control Center, but I wasn't sure how to pick the parent project for a particular provision. Is it even possible?
-
Report Filter by Current Job
Hi All: I have been working furiously for the last few months completely redesigning how we use Smartsheet since we purchased Control Centre. The automation is great but I have come across a load of roadblocks trying to manipulate Smartsheet and Control Centre to do what I need it to do. With that being said, I am looking…
-
Ability to add Sheet Summary Reports to Dynamic Scoping on Control Center
This functionality is available for "Row" reports, but "Summary" reports really should be included. Many clients use sheet summary to keep grids clean and lean; but, if we can't leverage dynamic scoping for those type of reports, it weakens the case for Control Center. It's either we bulk sheets up with columns to fully…