-
Data Shuttle - workflow & row options
Hello, I am trying to set up a workflow to bring in employee data based on certain filters. Once those employees are in the sheet, I need to keep certain fields updated as they change plus remove employees that no longer meet my filter criteria. What workflow actions and row options would I select? (I have all the columns…
-
Using Data Shuttle
I am considering using Data Shuttle, initially to update dropdown lists, and have a couple questions. First, is it fairly easy to get up and running and create flows of this type? Second, in a particular case, there are about 30 sheets that need a dropdown list updated from a column in a master sheet of about 500 rows. Not…
-
Notes, descriptions on my DataShuttles
Smartsheet, I'd like the ability to leave notes, descriptions on my DataShuttles. Much like I'm able to on Dynamic View. This will improve communication between DataShuttle owners and the shared parties without the need for interruptions. Screenshot of Dynamic View Thanks, Eric
-
DataShuttle import if source sheet changes, but name remains the same
I've just started working with DataShuttle to automate a few of our reports. We pull these reports weekly from SAP as an excel file, what we want to do is replace the file each week with the new file. These always download from SAP with the same name (EXPORT.XLSX), and I was wondering if this will effect the upload, or if…
-
How to copy all data from outside Control Center to new sheets?
My original process has almost 200 sheets outside of Control Center. I've recently setup a Control Center workflow and generated the same sheets based on the same template I was using outside of Control Center. How can I automate copying the data from the old sheets into the new sheets? I have access to Data Mesh and Data…
-
Can't make an offload data shuttle to a Sharepoint link
I want to extract my sheet smartsheet on a sharepoint which I have the access, but I can't. I don't know why, i have set up my workflow normally without any changes or filters, but the workflow don't want to success. Please help me!
-
Data Shuttle Date Formats - current crazy conversion
Need to be able to specify date formats in data shuttle OR for it to adhere to the formats in the uploading CSV file and/or smartsheet. For example: I have a CSV file to upload via data shuttle with date dd/mm/yyy. The smartsheet has the regional date setting of dd/mm/yyy BUT data shuttle takes a "best guess" and is…
-
Data Shuttle Export/Import
Hello, I am trying to use Data Shuttle to copy information from one column and paste it into another column by first exporting the master sheet then run an import of that export and it seems to be clearing all of my data or not uploading new data. The export currently exports all data with no filters. Below is the Import…
-
Excel Export Parameters - Data Shuttle
Hello Dear Smartsheet Community I would like to use my Smartsheet Data, to dynamically populate Email content… This being not "nicely" supported out of the box, I want to use a 3rd party app (Ablebits - Merge Email) which easily do this from Excel files pulled from "OneDrive". For this to work, I plan on upgrading to "Data…
-
Data Shuttle converting mmm d, yyyy date format to numerical value
Hello Everyone, I have a Data Shuttle workflow that has been run virtually every business day for over a year. When running today, four columns of dates converted to numerical values. No formatting of the source sheet has changed (Excel file with a Custom category of mmm d,yyyy Cell history confirms date format used to be…