-
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 Shuttle: Target sheet is empty but all rows are "unaffected" after running workflow
Hello, I am new to Data Shuttle and creating my first Upload Data workflow. My target sheet does not have any data in it: everything is blank (it is a new sheet). When I run the workflow however, the run details say that there are 77 rows unaffected (as in there are 77 rows where data already exists and is consistent with…
-
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?
-
Data Shuttle Folders
Currently all Data Shuttles appear in one list, you can view Offloads and Uploads separately. Finding a Data Shuttle you want to Run, view and update can be very time consuming if you have a lot of Data Shuttle workflows. Being able to put them into separate folders would be beneficial, this would also be of benefit in…
