-
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…
-
Data Mesh: Source report becomes "Not Found" after it's selected during Config creation
This is happening across multiple browsers and accounts, but just for one particular report. I can't use it in a data mesh and I'm seeing the message "Something went wrong. Please try again later." I go to New Config - Select Source sheet - and the report I want is visible, but then one of two things will happen: A. I…
-
Transpose with a merge
I have the following data set: A 1 A 2 A 3 B 10 B 20 B 30 B 40 C 10 I want to get it to be A 1 2 3 B 10 20 30 C 10 How to accomplish this in smartsheets when the number of items for each group are different?
-
Can I unlock the "Assigned To:" field in the Outlook Add-In?
Currently my organization is using Smartsheet to submit technical support tickets. When we submit these tickets, we would like to be able to assign them within Outlook, but the field is currently locked. Is there a way to unlock this field within the Outlook Add-In?
-
Dynamic selection of drop-down options in a form
Hello, I am interested in finding a solution to dynamically choose what options a drop-down list displays when a certain value is selected in another drop-down. As an example: We have Category 1 and Category 2 with the following options: and a form with 2 drop-downs - one for category and one for option. When the user…
-
Bridge: Way to delete all rows in a sheet
I've found a few ways to delete all rows in a sheet using scripts and multiple workflows, but I was wondering if there's an easier way to merge this into one flow. I just have the flow check if a row exists in get sheet, if there is a row then delete row 0, until the array = 0 then it stops. It works, but it's just super…
-
Not Bringing in ALL items from Sharepoint List
I am using bridge to connect to an existing list in SharePoint. This is part of a bi-directional connection I am making between my Smartsheet and SharePoint. I have been successful in pushing updates made in Smartsheet to Sharepoint. However, when creating the workflow to push updates (for separate fields from the push to…
-
Share Data Shuttle Workflows?
When someone creates a workflow in Data Shuttle to import data from a CSV file, how can we share this with other team members to support and adapt if required? Also if they are on leave, to enable other to run the workflow.
-
Update Column Formula with Control Center
Hi, I'm trying to update a column formula with control center. When I do Find/Replace and look at the test sheet, it's not updating. Original Formula :=IF(Summary@row = true, "", [Amount I]@row + [Amount II]@row + [Amount III]@row - [Allowance I]@row - [Allowance II]@row) New Formula: =IF(Summary@row = true, "", [Amount…
-
Smartsheet + DocuSign Integration
This discussion was created from comments split from: Smartsheet + DocuSign Integration.