Is there any way to move attachments from one row/sheet to another sheet?

Michelle St George

I have a form that users may complete with lots of information as well as submit attachments. The data is then used to populate rows on another sheet. Is there any way (was hoping for some automation?) to get row level attachments to another sheet instead of manually downloading them then uploading them?

NicoLHC

@Michelle St George maybe and easy way would be to download the file and the attach it from your Ondrive , SharePoint Location. Other way could be the new File Storage coming up or to use proofs and update requests direct in the target sheet.

Isis Taylor

@Michelle St George

Yes, you can use a sheet automation for this and any attachments included on the row will move too. You can use the automation below.

https://help.smartsheet.com/articles/2479626-automatically-copy-rows-between-sheets

Michelle St George

@Isis Taylor Thank you for the suggestion… Not looking to move/copy the whole row, only move the attachments (or even a link to the attachments in their existing location would work).

My use case, the form is submitted by an external party, and the data is made visible in a column in a project plan of sorts. I use INDEX MATCH to display the data but I was hoping to get to the attachments so they don't need to go to two different places…

NicoLHC

@Michelle St George maybe and easy way would be to download the file and the attach it from your Ondrive , SharePoint Location. Other way could be the new File Storage coming up or to use proofs and update requests direct in the target sheet.

Michelle St George

Thanks @NicoLHC - I'm going to encourage them to upload the files to a OneDrive instead of using the form then provide a column in the final sheet with links to the OneDrive instead