-
Control Center - Changing Auto-Generated Number
My basic question is if I want to change the auto-generated number on my sheet, do I need to account for the first two blank rows? These are locked rows with formula's. I want to have the first project start with the number 100 instead of 109. Do I start the numbering at 98, so that 100 will be on the first actual project…
-
Prefix/Suffix Form Names
Hi All, We slap on a generic name for our forms in templates so it's standardized in SCC. However, this opens up a chance to our users when they access a form, say "Daily Report", which then stays in their recently accessed items. In the scenario where a user will access to projects, the forms for both of those will say…
-
Is there a way to view activity logs across all reports / sheets provisioned through Control Center?
I am hoping to view an aggregated activity log for every report created in our blueprint through Control Center. Is this possible? Or is it only possible to view the activity log of sheets and reports individually?
-
"Triggering" Cross Sheet Cell Links After Project Spin Up
Hi, I have the primary data sheet in my blueprint with the Auto Number column type (called "Deal ID") that generates a unique ID for each new row. That ID is used to link other sheets in the blueprint so I can INDEX/MATCH to various data from the primary data sheet to sub-sheets. I currently have the Auto Number "Deal ID"…
-
DataMesh
What are the requirements to use DataMesh between two instances of SmartSheet. We would like to use DataMesh to update our sheet from a Vendors sheet outside of our company .
-
Trying to copy formulas from the Source Sheet to the target sheet using DataMesh
Hi, I've set up a configuration, that merges entries using copy from a source to a target sheet that is updated with the latest new rows. Copying of the data is working fine, however the formulas in the source sheet get lost in that process. Is there any way to avoid this? Background: I've an Excel sheet containing…
-
Is it Possible to (a) Delete and (b) Rename Columns Using Control Center?
Hi, Is it possible to delete and rename columns in a sheet using Control Center? I need to delete a column in a sheet (which was created using a Control Center blueprint) and then push that update out to all projects created using the blueprint. And also the same thing for renaming a column... Thank you, Ron
-
Is it Possible to (a) Delete and (b) Rename Columns Using Control Center?
Hi, Is it possible to delete and rename columns in a sheet using Control Center? I need to delete a column in a sheet (which was created using a Control Center blueprint) and then push that update out to all projects created using the blueprint. And also the same thing for renaming a column... Thank you, Ron
-
Dynamic View and calculated fields
I am currently setting up a status workstream tracking process using a combination of Smartsheet and Dynamic View. The Smartsheet tracker uses the WEEKNUMBER of the Created By date to show the 'Update Week', ie the week the update was entered, and WEEKNUMBER(TODAY()) to show the current week, in the following extract from…
-
Pivot: Add Row Links from source sheet
We're starting to dive in a make use of the Pivot app, and it is extremely powerful, however we are finding that it would be extremely useful for users to be able to affect the base data from the Pivot sheet more easily. One idea I have would be if there was a link in the Pivot sheet for each row directly to that row in…
