-
Data Shuttle - trigger from email to sheet
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…
-
Data Shuttle Merge and Append Master Sheet
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…
-
Data Shuttle not bringing in column as a number
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 is automated dropdown update limited to external sources?
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!!!!
-
Delete Rows using Data Shuttle Offload
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.
-
How to use Data Shuttle to add rows without erasing changes made to target 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…
-
Shuttle data: A whole column from one smartsheet (preferably filtered) to a new smartsheet
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…
-
Data Shuttle source stuck on loading external account
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?
-
Data Shuttle Import Different from Source Data - Decimal Places Issue
Hello, I have a data shuttle workflow that I believed worked really well. However, today, while thoroughly examining some data, I discovered that the source data isn't an exact match with the imported data. After investing a significant amount of time trying to determine the reason for this discrepancy, I believe the issue…
-
Data Shuttle Workflow Restrictions
Hello, My company is considering purchasing Data Shuttle, however, there are concerns that with only being allowed 50 configs, that they will be used up by 'unauthorized' users. Is there a way to limit or restrict the ability to create workflows to a select number of users in the organization? Or will the availability be…