-
How to use a smartsheet to update the form dropdown values in another smartsheet?
I have a smartsheet that contains employee names and employee IDs. I would like to use the employee names stored in this sheet to update a form dropdown list of employee names on a separate smartsheet that tracks employee activity. I was going to use data shuttle, however there is not an upload data from a smartsheet…
-
Data Shuttle Run Report
Hello, I have some Data Shuttle runs that I'd like to have report out to a dashboard so I'm aware of how many new rows are added and updated each day. Is there any way to display this data outside of Datashuttle?
-
Data Shuttle input not working at all-source field not mapped
Hi guys I have tried 50 times different scenarios and just can not get it to work. I'm trying to set up upload data , using 2 exactly same file one in my sharepoint personal folder second is the smartsheet , no matter what i do i always get source field not mapped and can not select anything else. I have tried to output…
-
Trigger Data Shuttle to run with the API
Can't schedule a data shuttle monthly, so maybe if we could trigger a workflow run via the API that would solve that problem.
-
Data Shuttle Synch Capability
Hello - I need to set up a sheet based on an employee roster that will be updated quarterly. I'd like to use a Data Shuttle upload workflow to attach the updated roster to the sheet and have it automatically remove termed employees and add new rows for those that are new hires, without deleting the existing rows in the…
-
Unable to disable DataTable connections to sheets. Has anyone encountered this?
I have not had any issues in the past with disabling the connections. I have 30 sheets with connections, when I disable the connections they show disabled but after a few minutes they become active on there own. The sheets have many connections to them via formulas (index/match) and smartsheet apps (dynamic view, data…
-
Data Shuttle Update not Updating
Hello, I have a Upload Workflow running where I am grabbing a sheet from a OneDrive location... and targetting it to update a sheet in one of my workspaces... No filters... When Mapping I am using a Unique Identifer Column thats in both the source and target sheet and based off that number I want it to update the status…
-
Merged: Data Shuttle Offload Data from Report format
This discussion has been merged.
-
Data Shuttle not adding entries
Hi all, I'm coming here for help. I'm currently trying to combine about 33 excel sheets into one file using data shuttle. Now the issue is that I might have as many as 3-5 people working on the same project. However, when I try to load the data, if the project code is already there, it does not add entries with the same…
