-
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…
-
Data Shuttle converting mmm d, yyyy date format to numerical value
Hello Everyone, I have a Data Shuttle workflow that has been run virtually every business day for over a year. When running today, four columns of dates converted to numerical values. No formatting of the source sheet has changed (Excel file with a Custom category of mmm d,yyyy Cell history confirms date format used to be…
-
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,…
