Skip to content
  • Try Smartsheet

    • Add Ons and Integrations

    Add Ons and Integrations

    Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.

    Data Shuttle Keep Data in unmapped column

    ✭✭
    edited 04/23/24 in Add Ons and Integrations

    We are using data shuttle to upload from a csv file once a week on Mondays. Throughout the week we have an assigned to column (that is not in the data source file) where people assign themselves to tasks (so different rows in the source file). They might not get to the task that week, so when we update the the data on Mondays we want their name to stay in the assigned to. Also they tend to leave comments on the rows with these be overwritten? Right now we I run the data shuttle it overrides what is in the assigned to column and the names disappears. It is possible to keep them?

    TIA!

    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Answers

    • Overachievers

      What is your setup on this page? If you have replace all target rows under workflow actions, it will delete everything and add back. If you use Merge, it shouldn't clear cells that are not mapped.

      image.png
      · Share on FacebookShare on Twitter
    • ✭✭

      Hi Samuel,

      I had it set up to merge and it was still deleting the info in my unmapped columns. I ended up just creating a new sheet and workflow and now it appears to be working.

      Thank you!

      · Share on FacebookShare on Twitter
    • ✭✭✭

      Strange. Mine is also removing data from unmapped columns, even though I have the "merge" option selected. I can't recreate the sheet and workflow, because it's tied to too many other things in the system.

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Quick Links

    Categories

    Trending Posts

    Help shape the future of Smartsheet.
    Share your ideas and feature requests.

     Watch video