-
DataMesh: Updates ALL rows, not only the changed row
It used to be that DataMesh would copy data from one cell to another per row. Lately, it has changed to updating an ENTIRE COLUMN if the value in ONE ROW changes. So instead of "1 row affected", it always thinks ALL rows are affected even if no changes are made to the other rows. This then triggers notification automations…
-
Onedrive & DocuSign Integration Capabilities
I am in the process of designing our Smartsheets workflow and am trying to better understand the capabilities / limitations of these integrations. Current Process: 1) We receive a PDF (say an invoice). 2)Manually save the file in Onedrive updating the file name. 3) Manually enter the data from the PDF into a SS Form and…
-
Control center - intake sheet data directly to summary sheet
This is a basic question but I can't seem to find a direct answer. When using control center , is there a way to get data from an intake sheet to the blueprint summary sheet without designating it as profile data? I watched SS university courses on control center and said there is a way but didn't show how to do it.
-
Bridge's Array Managment: Size/Length returns wrong length at times
I am using Search Sheet and Array Management Size/Length to determine if a project with a given ID has already been created. However, even if the array returned by Search Sheet is not empty, it returns a length of "0". Worse, it only seemed to have done this once so far (that I've found). This workflow has run dozens of…
-
Data Shuttle loses source when file is updated
Hi all, I've been experiencing an issue with Data Shuttle in which it loses its source connection when the source file (csv) is updated each morning. I set everything up and the source file is highlighted blue: The next morning, I'll add the updated file to the folder in which the source is located. It's probably important…
-
One user cannot select any sheets in the Jira Connector
We have a Service Account (that we use to set up all our Smartsheet/Jira workflows. Intermittently, when logged in as that user, we are unable to select any Smartsheet from the dropdown list (see image). The Service Account is a Sys Admin as well as a Jira Admin in Smartsheet, and is a licensed Member. It is an org admin…
-
WorkApp and Group Management Lists
Do Group Management Lists work for providing access to a WorkApp?
-
DataMesh and Attachments
Question for the Hive Mind, I need advice on the best way to handle a project involving two separate sheets that contain different but overlapping information. Sheet A is for internal data tracking (my team), and Sheet B is for external data tracking (vendors). I want to avoid cluttering Sheet A with unnecessary data and…
-
Pivot App doesn't allow date columns?
I have a source sheet that has the following columns: Project Code , Milestone and Milestone Date . I want to use the Pivot app so that it gives me a row for each project code, columns of Milestones and the corresponding dates for those milestones. Am I correct in understanding that the Pivot app cannot output dates? I…
-
DocuSign integration suddenly not working with contacts that display the name instead of email.
I've had a DocuSign integration working for a while now. Today, I go to use it and it doesn't work because it sees invalided characters. Upon researching, I have discovered that if the contact field displays the person's email instead of their name the integration works. So it's like DocuSign used to be able to use the…