-
Adding Cell Links to Existing Profile Data
For a period of time, 2 profile data fields were incorrectly set to One Time Write, rather than Cell Link. I need to correct this and add the Cell Link behavior for these 2 fields from the intake sheet to metadata sheets. I have tried the Add Profile Data trick to apply a pseudo Update Reporting Global Update, however that…
-
Feedback on SCC Portfolio WorkApps
Hello Smartsheet Team, I wanted to provide feedback on the SCC Portfolio WorkApps. Our project blueprint assets consist of 98 pages, which exceeds the current 50-page limit for WorkApps. However, not all of these pages need to be included in the WorkApps, as many are only required for backend purposes. It would be…
-
Include additional advanced formatting options in Global Updates
Per this help article, the following aren't available to configure when making column-related Global Updates using Control Center: Currency Percentage Thousands separator Decimal places Date format This makes the implementation feel half finished, as you still have to go into each sheet and make adjustments. These should…
-
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…