-
Is anyone encountering issues with Data Shuttle?
Doesn't seem to be recognising the file correctly? Keeps asking me for a source even though one has been selected. It's clearly recognising the file as it allows me to select the unique identifier column in the mapping screen, but won't actually allow me to map any fields.
-
Data Shuttle Specific Cell
I'm currently extracting data from excel attachments from one sheet into a new sheet. It's basically a list of items with quantity and descriptions which, at the top of the excel sheet, is an ID number (cell B2). I've configured Data Shuttle to extract the rows which start at Row 13, below all the identifiers i.e. date,…
-
Data Shuttle - Alpha/Numeric Sort of Dropdown lists
Would love to have the ability to Alpha or Numeric order my Data Shuttle Offload List so then when I go to do my Upload file, the new list has been Alphabetized or put in Numerical order. This way when my end user sees their dropdown list, it's easy to read or lookup values.
-
Data Shuttle not "seeing" new field in mapping screen
Hi Community. I have a Sheet which is tied to a Data Shuttle Workflow. I added a new column to my Sheet (trigger is attachment added to sheet). My new uploaded Excel attachment includes a new column called "Billing Cycle" (after column "Type". I also added that new column to my Smartsheet sheet. Now I need to map this…
-
How to exclude data from Data Shuttle when updating dropdowns
I have data shuttle setup to update dropdowns in a sheet on a daily basis. It is a list of equipment housing in our ERP system. There are certain pieces of equipment, 5 in total, that we would like to exclude from the dropdown list because they are not owned by our company but we need them in the master file because we…
-
Dynamic naming for files offloaded via workflow in DataShuttle
Hello everyone I was thinking that it would be nice to be able to name the files we offload with dynamic information like today's date or a cell value. This would allow for nice automated reporting of information when combined with the on schedule triggers.
-
Drop PDF to populate rows
As a sourcing analyst I have to take multiple pricing summaries from our consultants and enter the information into our Smartsheet. Currently that means a lot of copy and pasting and painful data entry. My question: Is there a way I can take the PDF they send me and drop it in Smartsheet and it auto populate my sheet based…
-
Merged: Data Shuttle Folders.
This discussion has been merged.
-
Data Shuttle - identifying point of failure
I am uploading a large data source. According to the error report, it is failing on 4 rows because the columns are restricted. I reviewed the columns an all appears to be in order - a previous upload worked seamlessly. Any suggestion on how to identify the 4 problem rows, please?
-
Schedule Data Shuttle for a Specific Day of the Month
Unless I am missing something, it appears that you are unable to schedule data shuttle on a specific day of the month. I have a monthly report that comes on the 10th that needs to import into Smartsheet. It appears the only way I can make sure data shuttle catches this is to run it every single day forever. There is a lot…
