-
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 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?
-
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…