-
How to copy all data from outside Control Center to new sheets?
My original process has almost 200 sheets outside of Control Center. I've recently setup a Control Center workflow and generated the same sheets based on the same template I was using outside of Control Center. How can I automate copying the data from the old sheets into the new sheets? I have access to Data Mesh and Data…
-
How to Ensure SCC URLs Open Project Dashboard by Default?
Hi Smartsheet Community, I’m working with Smartsheet Control Center (SCC) and have a Deployment Link column in my Portfolio Rollup sheet with auto-generated URLs. The issue is that clicking the URL sometimes opens a generic sheet instead of the Project Dashboard. Example of the…
-
Control Center Publish Link
It would save me a ton of time if Control Center could publish my sheets for me, set the default view, and pull the links back into the intake sheet. I have to do this manually soon for almost 200 sheets and I'm not looking forward to it.
-
Control Center: Published Link
I've got a control center blueprint that automatically provisions sheets from an intake sheet. Is there any way to automate publishing a sheet, setting the published sheet view, and pulling the published link back into the intake sheet? My template is set as published, but the sheets that are provisioned from it are not.
-
Control Center: Summary Data on a Different Sheet
In a Control Center blueprint, is it possible to send summary data to only one metadata sheet, then reference that data in column formulas (i.e. JOIN) from the project sheet? The need to have the summary data at the top of my template sheet is really screwing up my workflow. I have sheets that I want users to access via…
-
Move Control Center profile data to Sheet Summary fields
Having to list the profile data in the template is messy and distracting, and frankly looks pretty janky. You already have Sheet Summary fields tucked away on the side panel, able to run formulas, collect metrics, and link in data from intake. This would obviously require the ability to cell link out from Sheet Summary to…
-
How can I add a reference sheet to this formula - I have build another sheet that I want to add up
-
Control Center error too vague
I received the error message below when trying to add an optional sheet to an existing provisioned project. After investigating further with Smartsheet for several hours, we concluded that it was because the project folder had too many sheets. Had this error been clearer, we could have avoided this effort. You can refer to…
-
Control Center & WorkApps - Sheets show hidden columns on WorkApps
Hello, I've been asked to develop an auditing tool for users in the field that must be user friendly on a mobile device. I thought Control Center and WorkApps would be the perfect solution. Users can access a user friendly intake form from WorkApps and then the audit would be auto-provisioned into the WorkApps project…
-
Smartsheet Control Center - Blueprint Summary / Best Practices for Access
Hi - I had a question about a new field I noticed inside Smartsheet Control Center on the Customize Profile Data tab. This is the tab where you specify how the profile fields should be populated. I noticed a new field 'PERMISSION' in the box that I didn't see previously (bottom right corner of screenshot below). Is that a…