-
Data Shuttle
I am using data shuttle to upload a large spreadsheet to Smartsheet. The data shuttle program quit recognizing the first cell in my spreadsheet and I cannot determine why. I have tried changing this cell to both a text format and a number format and it still does not recognize the cell. I have remapped and refreshed…
-
Grouped Filters in DataShuttle
The ability to use grouped filters in DataShuttle would significantly increase the flexibility and usability of the import dialogue. Example: (1 AND 2) OR (3 AND 4). This would allow for more criteria to be added to the import filter to get more targeted data added to a sheet.
-
Offload Date Format
Hi, I'm using Data Shuttle to Offload a title and some dates and it is coming through with a really wonky format. Excel isn't able to auto convert this to a regular date and I tried using INT to try to make it into and integer but it returns a #VALUE! error because of the format. Is there any solution to this? This seems…
-
Data Shuttle Workflow Only Partially Uploading Data
In Data Shuttle I have an upload workflow. The source data is an excel spreadsheet with 14788 rows. The Data Shuttle upload is stopping after it adds 3832 rows and saying it is complete (no errors listed). The upload workflow does not have any filters so all the rows should be loaded. The Data Shuttle workflow has been…
-
Data Shuttle importing Values
When I use Data Shuttle to import data to a sheet, it keeps adding a ' in front of the numbers which turns them into text and not numbers. For example, $23.50 turns into '23.50 when imported through Data Shuttle. The original excel file itself is formatted correctly. Anyone know how to fix this?
-
Merged: DataShuttle Workflow Errors (Action:Replace)
This discussion has been merged.
-
Data Shuttle Issue
Looking to do a data shuttle and keep running into this prompt attached in the image. All the mapped data has unique names. This issue persists when trying to do a data upload. What would be causing this happen? Thanks
-
Data Shuttle - Unable to Map / Not Mapped
Hi there, I've been trying to set up a Data Shuttle workflow to replace all data with new attachment uploaded in another smartsheet. It was unable to map ANY columns even I try with the exact same data. It does not help either with changing any of the parameters in Data Shuttle. So the issue was that Data Shuttle will not…
-
Can I filter a contact list via Data Shuttle?
Hello! I'm interested in shuttling data from a primary sheet to secondary sheet by the contact assigned in two different columns on the primary sheet. I'd like to bring rows over where Maggie is listed as Coordinator or Back up Coordinator - 20 rows on the Primary Sheet meet this criteria when I create this filter: When I…
-
Data Shuttle Problem- No column header options
I'm trying to use data shuttle to link an excel file to a smartsheet file. The header columns on my smartsheet match with the header columns on my excel file. However, when I go to create the mapping, I don't see an option for my column header names from the excel file, it only shows: "Version". Additionally, if I deselect…
