-
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.
-
Data Shuttle: Will workflow run if file is attached via form?
Hello! Happy Friday! 😀 I am currently working on creating a Supply Request Tracker that will allow the requestor to upload their excel file with the list of needed supplies to a Smartsheet form connected to the tracker. The tracker will then use Data Shuttle to pull over the quantity, description, and item number of each…
-
Data Shuttle: update a checkbox in the source sheet to indicate success
Currently, Data Shuttle efficiently migrates data from Smartsheet to SharePoint, OneDrive, GoogleDrive, Box, & as a Smartsheet Attachment. This Providing a seamless integration between the two platforms. However, one aspect that could enhance user experience and workflow efficiency is the ability for Data Shuttle to…
-
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?