-
Data Shuttle isn't running - what am i doing wrong?
Hello, i have an upload data shuttle set up to run on attachment. i cannot get it to run. i need help to know what i am doing wrong.
-
Troubleshooting Automation: Copying Only Top/Parent Row Instead of Entire Project Plan
Can you help troubleshoot the automation that's supposed to copy only the top row/Parent row of the project plan (which contains specific key information) into the 'Timeline Variance and Weeks Remaining' sheet whenever a project plan is updated? Currently, the automation is copying the entire project plan instead of just…
-
How can I
I'm trying to find a way of updating the column Term Expiration Date with the New Term Date column. I currently have a workflow that once a date is entered into the New Term Date it copies that row to a new sheet. The problem that I am running into is if I use the Data Mesh, or Data Shuffle it tends to update…
-
Data Shuttle Folders
Currently all Data Shuttles appear in one list, you can view Offloads and Uploads separately. Finding a Data Shuttle you want to Run, view and update can be very time consuming if you have a lot of Data Shuttle workflows. Being able to put them into separate folders would be beneficial, this would also be of benefit in…
-
Help with sheet summary formula losing #REF with data shuttle
I have a dashboard created with a "Data Date" Metric at the top. Using the Created column to populate a "Data Date" column (text column +LEFT(Created@row, 18) I can add the date in the metric via a sheet summary field. When I refresh data pulled from an Excel sheet (exported by another program), I get a #REF error in the…
-
Datashuttle: source not found when updated
I have a situation where a SharePoint folder is updated every week by uploading a file with the same name and columns each time. I have set up a Data Shuttle to upload this data to a datatable, but it doesn't work because the file is deleted and replaced. What other solutions do you suggest?
-
Keep Search Text in Data Shuttle Workflows List
I have well over 100 Data Shuttle workflows, and they are cumbersome to work with. I appreciate the ability to search, but I've found that I have to re-enter my text in the search field over and over again as I'm moving in and out of workflows. If I click into a workflow to view something, when I return to the main…
-
Data Shuttle - Notifications if Unique ID is Missing?
Hi all! I'm setting up a data shuttle to automatically update our records when we receive inventory reports from a third party vendor who manages our warehouse. The trouble is, we've noticed that some of our items have fallen off their reports, and we need to keep an eye on this week over week. I'm trying to see if there…
-
Data Shuttle -> Run Options based on Sheet Changes
It would be fantastic and a big save on computing power if there was an option for Data Shuttle - Run Options to be scheduled "Anytime changes are made to a smartsheet." I have many Data Shuttles that don't need to be run regularly, but only when updates are made to the source sheet. I believe this option would save a lot…
-
Data Shuttle: Missing Rows/Entries
I have two workflows in DataShuttles set up to track costs on a monthly basis in a single sheet. One workflow is called "Current Month Cost" and the other is "Previous Month Cost." The sources are excel files from an external database that I have no control over. Every month, I take the previous month's excel file and run…