-
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…
-
Option to Toggle off Admins Receiving Access Request Notifications
With the new update rolled out last month, all sheet/workspace Admins now receive access request notifications instead of just the Owner. This is causing major headaches for the large corporation I work for. We have thousands of users and many do need Admin permissions to perform their tasks in workspaces. However, they do…
-
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…
-
Control Center Global Update Text vs Numeric
I'm working in Control Center on a Global update to change a field from "N/A" to 0 (aka zero). When testing the update I noticed that it changes to the text of "0" as it's left aligned vs right aligned. Any ideas how to update from a Text to Numeric via Global Updates? I've tried different variations to force numeric:…
-
Blueprint SheetSummary Formulas
In the Blueprint project plan, there are Sheet Summary formulas, providing the 'Category' & 'Initiative' from the Project Metadata sheet. See below: =({Project Metadata | Category}) =({Project Metadata | Initiative}) I need to add a new SheetSummary formula in the blueprint project plan to pull in the 'Workstream' from the…
