Shuttle data: A whole column from one smartsheet (preferably filtered) to a new smartsheet

Eric Sivacis

Hello

Im having trouble..

I have a SourceSheet that im not admin to.. where from i want new rows of a certain column to continously be added to MyOwnSheet

Ive set up a offload, and when i create the complementing upload data shuttle i cannot find the file that i believe is suposed to be created during offloading..

I first set up a offload and then when i set up upload in the Select source file stepi get: Attachment with name "Sheet with column i want to shuttle" was not found
I follow this guide:

https://www.youtube.com/watch?v=11d1jSCmRq0

How can i set up a data shuttle that will make a new value to the important column in SourceSheet be copied into its new created row in MyOwnSheet?

Philip Robbins

Hello @Eric Sivacis, have you triggered the offload workflow so there's actually an attachment in the sheet? When creating an upload from an attachment you do need a copy of the attachment to be there, otherwise you won't be able to do any column mapping, etc.

Danielle Wilson

Hi @Eric Sivacis, that should definitely work, but I would make sure you can find the attachment (might take doing the offload, being clear where the file is going, and then waiting a while before creating the upload workflow so Data Shuttle has time to see the file).

Alternatively, what is a better way to do what you are attempting to do is DataMesh, since this is explicitly a tool to copy rows (or parts of rows) of information from one sheet/report to another sheet in Smartsheet.