-
Does a workflow in a Data Shuttle have the ability to pull an updated report in a SharePoint Folder?
I have set up a workflow in one of my sheets to have the source location as "OneDrive & SharePoint" and then selected the file from a specific folder. In this folder, a new report is posted weekly and I would like the workflow to select that new report each week to update the workflow. Is that possible? I know you can do…
-
Unable to Access Large Sheets But Data Still Accessible
I've been having an issue the last couple of weeks with two very large sheets. One is automatically updated via Data Shuttle and the other has rows pushed to it weekly. I can't open them directly but I know they are still functional because I can still move rows to them, other sheets can access the data via formulas, and I…
-
Update Dropdown List Options
Are there any recommendations on how to maintain dropdown options for a Control Center template? We have a Change Log template where one of the columns is 'Impacted Applications' with a dropdown column property. The list of options change periodically and each time that list changes, we currently need to rollout a global…
-
How can I convert date to text?
Hi, I'm setting up data shuttle where unique identifier can be in multiple dates and would need to make sure all data in multiple days flow. In excel, I have a helper column as =ID&"_"&TEXT(Date, "yyyymmdd") to set as an unique identifier. From the Smartsheet that has a date of 7/23/24, how can I convert this into…
-
Data shuttle adding new rows far below existing rows
I'm having a weird problem with a data shuttle that previously worked flawlessly. I have a sheet which includes about 150 rows of information. I run a weekly data shuttle to add/update rows to the sheet. The data source for the shuttle is an Excel file. New data rows are added to the end of the sheet in the next available…
-
Is it possible to offload data into data shuttle from a report?
Is it possible to offload data into data shuttle from a report and not just a sheet?
-
I have a blank sheet that i want to populate with only the column values from another that contain X
Hello I have a fresh blank sheet, and another data sheet that for example contains the Columns: Fruits, Fruit price/kg, Inventory, etc I want to in my new blank sheet have a Fruit column that only includes the ones with string "apple" so data sheet may contain: Pineapple, green apple, red apple, AND, Orange, Banana,…
-
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…