-
Just Released - Data Shuttle Search Bar
Hi Community, If you have as many Data Shuttle workflows as I do, whenever you’ve gone to edit a workflow you have probably felt the pain of scanning through a very long list to find the specific workflow in question. Well now we have a search bar in the “All Workflows”, “Upload Workflows”, and “Offload Workflows” pages of…
-
Are You Able to Join Two Columns into a Data Shuttle Dynamic Dropdown?
Hi everyone, I'm hoping someone here can help me out with a challenge I'm facing in Smartsheet's Data Shuttle. I've been trying to use expressions to combine two columns into a single dynamic dropdown column in a target sheet, without changing the source sheet. For example, I want to combine Num and Name into a format like…
-
Data Shuttle Automation Question
Hi, we are exploring data shuttle for a welcome kit program. Smartsheet has told me we can connect with ADP workforce now but I can't understand how automated it is. HR wants to not have to do ANYTHING. i.e. they enter a new employee's information into ADP workforce now and it automatically flows the critical info (name,…
-
Why my Data Shuttle workflow been archived automatically?
I created a data shuttle workflow to upload a file from SharePoint, but it has been archived by smartsheet automatically. Could you please help to let me know what's the reason?
-
Data Shuttle Offload keeps deleting other Excel tabs
New to Data Shuttle. I created the offload workflow successfully to an excel tab and it overwrites the entire file. My other tabs which will calculate the data on tab 1 after it's refreshed just disappear. What am I doing wrong, please?
-
Time format data change after uploading data to smartsheet from excel via Data Shuttle.
I am using data shuttle to upload data from local .xlsx file. Below is the data available in .xlsx file in "hh:mm" format. After uploading data to smartsheet by data shuttle, The value is changed and showing in below format. .xlsx file is generating from system automatically so i can not change or add any filled in .xlsx…
-
How Generate Quotes Via Smartsheet
I am looking at making our internal quote system entirely through smartsheet. Is there a way in which i can expand a row in order to make relatively complex quoting system which almost acts as a mini excel sheet per row. the output would be a price but if needed the breakdown is seen. I would like the the Quote numbering…
-
Data Shuttle capacity?
Hi there - I am designing a process where we will likely have over 150 different Data Shuttles (3 DS x 50 people) that need to run at least once daily. One will be every 15 minutes, another will be on attachment (resulting from the first one), and a third will be once overnight. Can I expect Data Shuttle to be able to…
-
Data Shuttles aren't processing on upload
I can process them by clicking RUN, but they won't process on upload. Any ideas on why?
-
Enhancement to update Data Shuttle to recognize/preserve leading zeros in front of numbers
Use case: Managing hundreds of cloud accounts that have a fixed length ID and a randomly assigned number. Some account IDs have 1-3 leading zeros, some have none, as long as the overall length is 12 digits. Issue: When using Data Shuttle to import updated lists of accounts, existing accounts with leading zeros, are deleted…