I am trying to use data shuttle to upload data from an excel file in SharePoint but when I get to the mapping part, the column names are completely different from the source. Almost as if it is not pulling the data from the sheet I specified, but a different one. I am using the second tab of the excel sheet and some of the…
I have a sheet that I currently update using a CSV file that is emailed to me weekly. I set-up a Data Shuttle to run upon attachment that works great. But I'm trying to remove a step. Is there a way to email an attachment to a specific sheet that would then trigger the Data Shuttle so I don't have to manually upload each…
Hi all, hoping someone can clear up a misunderstanding or provide a workaround here. I have a number of 'sub-sheets' that I would like to merge into a Master Sheet. They are all the same format have the same columns and have a common key column that can be referred to when SS is working out whether to add a new row or…
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…
I have a data shuttle to bring in a csv with numbers and dates. There is one column that is a number (formatted as a number in excel) that populates a column in SS that is a text/number column. I have a formula that uses this column but it does not work because DS is not bringing the data in as a number. I have tried…
Why can dropdown values be updated from external sources (csv., xlsx, google sheet) using data shuttle but not from internal smartsheet sources in data mesh? This would be a tremendous possibility to work in a smartsheet environment!!!!
I need to automatically delete rows. I set up an Offload workflow in Data Shuttle and the rows I wanted deleted are there, but they are also still in my source sheet.
I am using Data Shuttle to transfer a sheet of individual people activity from a source sheet to a target sheet. I want to be able to add notes to the target sheet or check boxes in columns that are on the target sheet and not the source sheet. I set up DS to merge data into the target based on a key column value. Each…
Hello Im having trouble.. I have a SourceSheet that im not admin to.. where from i want new rows of a certain column to continously be added to MyOwnSheet Ive set up a offload, and when i create the complementing upload data shuttle i cannot find the file that i believe is suposed to be created during offloading.. I first…
I am trying to connect Data Shuttle to my OneDrive but it is stuck saying "Loading…" I have let it load for a while and it seems to never change. Any ideas as to why this is?
