-
Datamesh - blanking mapped columns
In Datamesh, when the lookup value in the target sheet is blanked out (delete) or even changed to a value that has no match in the source sheet, all the mapped columns in the target sheet remain with the previous value which makes the data not consistent. Is there a was to blank out the mapped value if the lookup value is…
-
Workflow - Generate Document
Hello everyone, I am using the 30-day trial in Smartsheet to convince my bosses to implement this program. I am setting up a simple sheet that our service techs fill out after each job they complete. When the form is completed I want the Workflow to generate a PDF document that I have all mapped out. But, for some reason,…
-
Control Centre - Adding an Optional Template to a provision Project.
I am attempting to add a new optional template sheet to a provisioned Project via Control Centre. When the new optional template sheet is added to the Project, the references, and some cell links are broken. Is it possible to add an optional template to a Control Centre provisioned project and have the references and links…
-
Pivot App creating unwanted columns filled with 0's
I am baffled by the behavior of one of our Pivot tables. When we run the pivot, we receive unexplained columns filled with 0's. Here's the source report, a report of outstanding tasks and their End Months: We used the Pivot app to view the End Month as columns and this is the result: The problem is the first column: "2023…
-
Document Builder Docusign Declined Comment
Hello, I'm trying to use Document Builder to start a document in SS, route in Docusign, then pull back into SS. Its working well as long as it gets approved - but I'm looking for a way to capture the Comment entered by the DocuSign users if they reject/decline to sign. I want that DS comment to sync into a column in the…
-
Bridge + SharePoint Integration
From all the videos I've watched and materials I've read it seems that Bridge is used to bring info into Smartsheet. What if I want it to share intake requests FROM Smartsheet TO SharePoint? I have this use case to share intake requests between departments that's using different systems. Currently it is being done…
-
Integration with DevOps
I'm looking for some help setting up my integration from Azure DevOps to Smartsheet. Anyone have experience with that integration?
-
What's the difference between Bridge and regular automations?
It seems to me that regular automations inside sheets can do most of what Bridge can do, based on the demo available, yet it's a separate product, so I can't try it myself. Can anyone tell me the difference/advantages of Bridge? Thanks!
-
Deleted Columns & Power BI
Hi All! I seem to keep running into this when myself or another team member deletes a column in smartsheet, and ends up breaking a sync in Power BI. Often we'll remove columns from a sheet that aren't actively used on PBI reports, but are either part of the source sheet or report. This breaks the sync, and it's kind of a…
-
Data Shuttle + Data Table: Move Row Repopulation
I have a large Data Table that gets fueled daily with fresh information. There is a 'KEY' column that uniquely identifies each ROW of data. Using a Data Shuttle, I am fueling a regular sheet with only SOME of the data from the Data Table. Unfortunately I cannot find a way to filter the Table with ANY (and) ALL logic. What…
