-
Data Shuttle Upload Filters
I am using Data Shuttle to upload Smartsheet's own Users.csv report into a sheet. That report has multiple TRUE/FALSE columns. I was trying to apply a filter to one of these columns. In my target sheet all of these Booleans are configured as checkbox columns, and all columns are mapped. It took me about 15 attempts to get…
-
Troubleshooting Data Shuttle
I am having issues with Data Shuttle adding rows at the bottom. It seems to be skipping 20+ rows in Smartsheet when my data source doesn't have those blank rows. I did add a filter to filter out blank rows. Any suggestions?
-
I need Data Shuttle to work with Trailing Zeroes
This is a huge pain point for me. I often have Data Shuttle lookup values that end in a zero (like 6457813.54610). When I set up a data shuttle, the rows that have a trailing zero don't pull back match when the Data Shuttle runs. I REALLY don't want to have to write a function that says: look for the "." and if the count…
-
Data Shuttle Price and features
Hi. Can someone tell me the monthly subscription fee of Data Shuttle please? The only feature I expect to accomplish with Data Shuttle, is to auto-update the dropdown column values, by linking the given dropdown column to another column / sheet of Smartsheet. By this I mean I will not be importing data from any external…
-
Getting Data Shuttle to recognize a column as number/text, not checkbox
I'm in a pickle. I set up a Data Shuttle that imports a CSV, but the target sheet recognizes 0s as a checkbox. I need it to recognize the 0 for the formula. When I try to change the column type (Actual Work in the screenshot) from Auto to Number, it won't give me that option. Changing the column type in the source sheet…
-
Data Shuttle not deleting rows
Hi all, Im new to data shuttle, implementing my first workflow.. overall its working fine, but what its not doing is deleting records when I attach new data to my source sheet. The scenario is, the source sheet contains a row thats not in the updated data. My expectation is when data shuttle runs it finds a target row…
-
Simple Data Shuttle filter question
I'm embarrassed to ask this, but how do I set up the simplest filter within a Data Shuttle workflow? There's one column - titled Onsite or Web - where I only want to pull rows with Web. What would I put for the filter? I've tried (1) where Onsite or Web equals Web. I've tried every other combination. It doesn't end up…
-
When I upload a smaller file to my Data Table will it remove the old data if it exceeds the new?
Hello,, I'm figuring out data tables slowly and a question I have is if i upload a csv with 200k rows to my data table, then i turn around and upload the same file but it only has 150k rows, will it delete the extra 50k? thanks, Spencer
-
Data Shuttle Offloading Wrong Data?
Hello, I have a main data source which collects project information from different vendors. Figure 1. Example of main sheet row To work with outside vendors, we have public facing sheets that we offload data to using data shuttle. Figure 2. Data Shuttle Offload Criteria This data is then uploaded to the company's sheet…
-
Data shuttles
If I am not planning to share a file in another platform, why would I need to "off-load" data from a smartsheet file? Must "off-load" be used to pull the data into another smartsheet?