-
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?
-
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…
-
Exporting/Sharing Filtered and Indented Sheet View
I'm looking to find a way to share a filtered view of a project with a supplier. I would like to either share a live view or schedule sending an updated version of the project plan weekly. The issue I'm running into is that there doesn't seem to be a way to to do this in a way that the rows are both filtered and indented.…
-
Smartsheet Sources/Destinations in Data Shuttle Not Loading
Title says it all but wondering if anyone else has this experience and knows what to do in addition to contacting support? If I'm doing an offload or upload, whenever I click on "select the source/destination sheet" this is all that happens, for hours, with zero change, just these two spinning dots. It worked fine…