-
Add Delete Rows that Don't Match Filter Criteria Option for DataTable
Because there is no way to delete DataTable entries from a Data Shuttle workflow, I have to abandon the use of DataTable. Because I am unable to delete entries via Data Shuttle, DataTable connections have been pushing out of date and incorrect information to my sheets. I am hoping the DataTable and Data Shuttle product…
-
Increasing issue with corrupted sheets
Is anyone else having issues with specific sheets not being accessible? I now have two sheets that throw the "An error has occurred in Smartsheet" failure text. Smartsheet was unable to recover the first sheet where this happened and we were forced to rebuild the sheet and 20+ reports associated with it. I now have a…
-
Data Shuttle / Cell Links
Hey all - I am uploading a report from our ATS program from a google sheet using data shuttle to put it into a smartsheet form. I added check boxes into the smartsheet form for the responsible parties to mark off which stage they have completed from the report. Since I don't want to lose the data, I am adding new rows for…
-
Is it possible to set up a data shuttle from a sheet summary?
Hello! I have sheet summary formulas that collect various metrics on my data. The sheet / sheet summary is updated every time we attach a file to it (which is at least once every business day). I would like to capture the sheet summary metrics at a specific time interval - maybe once per week - and add them to a new row on…
-
Data Shuttle Failed: Server Timeout - Sheet over 20K rows
Hi SmartSheet Gurus, This week I started to experience workflow sync timouts with a Data Shuttle upload on a sheet that has is over the 20k row limit (On Roadmap Phased Approch). I believe due to the size of the sheet a connection cannot be made and henece the workflow not sycning. Would it be possible to have someone look…
-
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…
