-
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…
-
Updating Project Schedule dates using Excel Spreadsheet (duration causing issues)
I have a schedule that is thousands of lines long. I have a .xlsx file with my unique identifier (Schedule Item #) in one column, activity description, start, and end dates in my file. My Smartsheet settings are set to automatically calculate the duration of the duration in a separate column based on the start/end dates.…
-
Creating unique participant IDs
Hi all, I am looking for a way to generate unique IDs for individuals filling out forms. We have a number of events for which we have made registration forms. When a person fills out a form, we would like to have the corresponding sheet automatically generate a unique ID for each person that is de-identified. Is there a…
-
How to download data into table view?
The new feature Table View that was announced says it can hold 50,000 rows as opposed to the 20,000 in a normal grid view. However, whenever I am using data shuttle it cannot load all of the data. I had a data set with 16,000 rows and using data shuttle from drive it uploaded all of the data no problem. I doubled that data…
-
Premium Apps and Workflow Automations Questions
If I make a workflow automation or set up a premium app like Data Shuttle and Dynamic View while I am an Admin under the legacy model, will those Workflows and Premium Apps that I set up be disabled once I get demoted to Viewer under the new User Subscriber Model?
-
Contact field list management (data shuttle or groups)
Managing contact field lists for numerous sheets is time-consuming and subject to error. The ability to manage this by using Data Shuttle to update the contact field options OR being able to select a "group" for contact field options allows this field to dynamically update from a central location.
-
New Data Integrations Panel in table view
Hi Community, We are excited to announce the arrival of the Data Integrations Panel in the new table view! The Data Integrations Panel allows you to connect your sheet with external data sources via Data Shuttle, such as files stored in drive locations like Google Drive, OneDrive, Sharepoint, Box, and Smartsheet…
-
Options for appending data
I have a file, actually multiple files, one for each account. Each month they will get new data that I will need to append (add to the bottom) in 5 of the 23 columns. Is that possible in any way, or will I be forced to do copy/paste/ We are looking into Data Shuttle, but the only license is that of someone that already has…