-
Data Shuttle Not Updating Cells - Can Any one Assist
I have set up a data shuttle to export a list of e-mail addresses, with one other collum which is an autogenerated number which is the unique ID, this works fine. When I came to run another data shuttle to import this file into another sheet, I set up the settings, selected the unique ID to the autogenerated number collum…
-
Offload and Upload (Data Shuttle)
I was following the instructions here to automatically update dropdown values, but could not get the offload to work (as in the workflow runs successfully, but does not create a file). Thanks for your help.
-
Data Shuttle Issues
I am using Data Shuttle to export certain rows that meet certain criteria from a sheet. The goal is to have this run during a certain window of time, check where the criteria are met, put the rows into a csv file, and attach it to the same sheet as the source, replacing the old with an updated one every 15 minutes. The…
-
Hyperlink manual trigger data shuttle workflow
As of now the data shuttle workflow can only manual trigger in the data shuttle page by clicking on "Run". My idea is to allow user to trigger running a workflow by hyperlink/webhook. So user can add the link in their dashboard as a function of Button. To manual trigger the data shuttle workflow when they are reviewing the…
-
Why is my workflow not updating my Smartsheet columns after initial run?
I have set up a workflow from an excel file to my smartsheet. I have it set that whenever a new sheet is added it should update my data, but that is not happening. Ex. One of the columns is for prices. If the new source attachment has new prices and i add to the workflow, the price does not change in the Target sheet when…
-
Data Shuttle Folders
Currently all Data Shuttles appear in one list, you can view Offloads and Uploads separately. Finding a Data Shuttle you want to Run, view and update can be very time consuming if you have a lot of Data Shuttle workflows. Being able to put them into separate folders would be beneficial, this would also be of benefit in…
-
Data Shuttle: Target sheet is empty but all rows are "unaffected" after running workflow
Hello, I am new to Data Shuttle and creating my first Upload Data workflow. My target sheet does not have any data in it: everything is blank (it is a new sheet). When I run the workflow however, the run details say that there are 77 rows unaffected (as in there are 77 rows where data already exists and is consistent with…
-
How can I use index match + either another index match or an IF statement to pull Data from multiple
How can I use index match + either another index match or an IF statement to pull Data from multiple sheets? In my case I have 3 sheets: Sheet 1 - Current Project List - consists information that track active projects. (each Project has a unique project code) Sheet 2- Closed Project List - consists of previous years…
-
Rank Pivot Results WITHOUT DUPLICATES
Hey friends, I am trying to create a column that ranks (without duplicates) the results of a PIVOT configuration. The PIVOT config produces the SUM of rental dollars spent, in column "Grand Total-SUM 💲 Total Rental $ Amount {H}" respective to each listed equipment type, in column "⚠️Cat-Class Description". I'd like to rank…
-
Combine emails into a multiple-contact column / multi-contact column
Multiple-contact columns can be problematic to use in Smartsheet. Namely, they cannot be "put together" with a formula. There's many use cases where you need to build multiple contacts into a cell based on criteria/lookups, but there isn't a way to do that in native core Smartsheet. There is, however, a couple of methods…
