-
Smartsheet Sources/Destinations in Data Shuttle Not Loading
Title says it all but wondering if anyone else has this experience and knows what to do in addition to contacting support? If I'm doing an offload or upload, whenever I click on "select the source/destination sheet" this is all that happens, for hours, with zero change, just these two spinning dots. It worked fine…
-
Data Shuttle Error
Hi All, I am hoping someone can help me with this data shuttle error: Workflow Execute: Your workflow maps columns that no longer exist. Please refresh your mapping to remove the deleted columns. While normally I would go in and refresh the columns, and it would be fine, this time I am copying all of the columns verbatim,…
-
Data Shuttle Merge
Hello. I have a data shuttle set up to merge changes into a grid. I have a column that is called ID in both that is the same, but when I run it no changes are made. I have added fake changes to ensure something would happen but still nothing. My thought is maybe since the ID is a concatenation of other cells in both the…
-
Removing Duplicates while also adding together values from other columns
I have a bit of a complex situation. My company uses SAP for purchasing and we pull an open order report weekly to keep track of each of the buyers orders and delivery dates. I've recently set up a Data Shuttle so we can transition from manually editing the report in Excel to a more fully automated report in Smartsheet.…
-
Data Table: Automatically Updating Source and Target Sheets
Hi all! Coming to the experts for this… My company has 20k+ employees, so I cannot have all their employee information on one sheet. Instead, I've broken it up into two different sheets: one for executives; and one for non-executives. I'll refer to these as the "main sheets." I also have different sheets for each of our…
-
Data Shuttle to DataTable: Replace DataTable
I want to create an automated system that maintains my DataTable as an exact replica of a source file. Data Shuttle does not quite do this for a DataTable workflow. In the Data Shuttle workflow for DataTables you can only Add and/or Update data. This can result in rows of data remaining in the DataTable when they are no…
-
How Can I Automatically Remove Outdated Rows for Updated Project Data?
How can I automatically remove outdated data from Sheet A in my Smartsheet, which pulls project data (weeks remaining and timeline variance) from multiple project summary sheets? Whenever a project's data changes, Sheet A adds a new row with the updated information, but I want to ensure only the most recent data is shown…
-
Is it feasible to automatically transfer input from form data with added formatting and information?
Hi, I am attempting to reduce the need for manual data entry. Essentially, I would like a system where a sales colleague can check off a list of processes when they receive an order, lets say A, B, and C. A new sheet is created for production showing they need to complete processes A B C. The problem I am facing is that I…
-
combining two smartsheets into one new
I have access to two Smart sheets that my colleague updates, can I create a joined sheet which I will own but the data will come two the two other sheets?
-
Data Shuttle Delete Rows
when doing a data shuttle where delete rows is enabled, do you know how to automate moving the delete row to a different smartsheet via automation steps.