-
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…
-
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…
-
DataTable - Lookup Mode with multiple values
I am attempting to use DataTable to pull compliance information into a sheet. The target sheet has columns for Code, Division, and Compliance Status. I need to match on both the Code and Division columns to populate the Compliance Status. However, I need to use the Lookup Mode function to connect the DataTable and cannot…
-
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…
-
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…
-
Checking provisional members on Smartsheet for USM model
Hi smartsheet community! I wanted to check if there is any way by which we can check who all are provisional members in our existing user list. Kindly note that we have not ye to move to User Subscription Model. Thank you for your response!
-
Program Toolkit: How to rename program through control panel & Keep existing cell links.
I have several program folders with smartsheet templates connected to a blueprint, managed by Control Center. My question is this; How do I change the program name of a folder and its sheets while retaining all existing cell links? Additionally these programs roll up into other sheets for reporting and dashboards, These…