-
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…
-
Data Shuttle - Remove row that is no longer is source sheet
I use Data Shuttle to upload current enrollment data for our courses. I have a unique identifier because the source sheet has duplicate entries, but I only need one in entry in Smartsheet. Has anyone come up with a solution to remove the a row that is in Smartsheet, but no longer in your source sheet? Sometimes courses are…
-
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…
-
Data Shuttle - Delete Rows No Longer In The Source File
I am trying to use Smartsheet and Data Shuttle to automate an open order report that we use. Part of the reason that we're trying to switch it over to Smartsheet is that we want it to be a living document, so that our buyers can write their notes for each order and see what is happening with other buyers orders should they…
-
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.…