-
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…
-
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?
-
A way to create a hyperlink for each rows attachment as a column
Hi Smartsheet Team, Is there a way to create a column in a sheet that is the hyperlink/link for the attachment of each row? I am using data shuttle to offload sheet data and the attachments aren't included in the csv file. I thought a link or hyperlink column would be a workaround for this. Any help is appreciated. Thanks…
-
Data Shuttle
I am trying to build our project using the PMO template. We receive a monthly data report that lists all projects and based on a select criterion, those that meet will be accepted as new projects. I want to automatically add those projects to the intake form to create the master template. I've added the data report as a…
-
Data Shuttle adding rows not triggering automation
I have an automation set up that when a row a added and [*department* Completion Status] is empty them change [*Department* Completion Status] to "WIP" Does Data Shuttle trigger automations to run? if not is there a way to work around this?