-
Data Shuttle Issues
I get an CSV weekly with all the new hires at my company. After the new hire's start date is in the past, they drop off the list. I want to have a Data Shuttle that takes this CSV daily and updates + adds rows for every new hire. There is also about 20 columns that need to be filled out on this Smartsheet. I have tried…
-
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…
-
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: 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…
-
ERROR Data Shuttle : Workflow Execute: [object Object]
Hello everyone, I have been encountering an error for some time on Data Shuttle. This is: "Workflow Execute: [object Object]". But I don't know what it means. Do you think you can help me? Azerty64
-
"Please select a Target before configuring the Mapping" error in Data Shuttle
In Data Shuttle, I'm running into a "Please select a Target before configuring the Mapping" error on the Mapping page, but I've already selected a Target sheet. Mapping: Target: I ran into the error when creating a new workflow, so I went to an existing workflow to see if I'd run into any similar issues. I Next-ed through…