How to use Data Shuttle to add rows without erasing changes made to target sheet?
I am using Data Shuttle to transfer a sheet of individual people activity from a source sheet to a target sheet.
I want to be able to add notes to the target sheet or check boxes in columns that are on the target sheet and not the source sheet. I set up DS to merge data into the target based on a key column value. Each time DS runs it erases all information on the target sheet and replaces it. I've tried this with different row options (add rows or add rows and update or just update) with no success.
Ideally, I would add new rows and update information on existing rows without removing comments, or data added to columns not on the source sheet.
Thanks, Sara
Answers
-
Hi Sara, thats not typical behavior. The comments and other column data should remain.
My first thought would be, what's your data shuttle run frequency? And Are you able to save the info in your target sheet before the workflow runs again?
-
How can i shuttle data from one sheet that i dont have admin powers in to another that i do?
-
@Eric Sivacis I answered on your other post, but I'd recommend DataMesh instead of Data Shuttle for this
Danielle W.
Product Marketing
Smartsheet
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives