-
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…
-
Exclude blueprint folder name
Does anyone know what this option on the Naming configuration does? I can't find any specific documentation or examples... Thanks!
-
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
-
Filters not working with date hierarchy in Power BI
I'm working on a cumulative sales by Dates. To achieve this, I followed below steps - Create Date dimension with calender(startdate,enddate) function Map Date table and Sales table with bidirectional many to one relationship (tried single directional too) Create cumulative sales measure (replace blank sum(sales) with 0 for…
-
"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 .
-
Mail Merge with Form
Hi all, I was searching on the Smartsheet community, but i could not find the best solution for my issue. Basically, in my company, everytime that a production finishes, i receive via e-mail the test results for the specific product. With those results, later on, i must issue a document to the customer with those same…
-
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
-
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…
-
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…
