-
Data Shuttle off of Attachment
Hello, I have a data shuttle that stopped working when the owner left the company. I rely on this data shuttle for important barging updates. I used to be able to attach the most recent excel document to all attachments every morning and the sheet would update. Now it is just giving me dates across all of the cells. Please…
-
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?
