Is there a way to copy or link an attachment from one Smartsheet to another?

I have two smartsheets. The first, Order Sheet, collects submitted order info from a smartsheet form. The second, Shipping Sheet, has shipping info for both submitted and other/autogenerated orders . I am using Index/Match to pull shipping dates and tracking info from the Shipping Sheet into the Order Sheet. I would also like to be able to pull over or link the attachments from the Shipping Sheet to the Order Sheet. Is this possible?

I'm open to other out of the box solutions that might work as well. In this case, it makes sense to keep these two sheets separate.

Find more posts tagged with

Attachments

Automations

Workflows in Smartsheet

Accepted answers

Genevieve P.

Hi @Shawn Church

There currently isn't a way to use a formula or another function in Smartsheet to sync the Attachment field from one sheet to another. You could copy an entire row from one sheet to another (which would bring over attachments), but this would include all data from the original sheet.

What I would personally do in this instance is create a Row Report using both of the sheets as the source. Then I would Group by the unique order number (or the matching value across sheets). This would bring the two rows together under one heading to easily access both sets of data, including attachments.

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Shawn Church

Cheers,

Genevieve

Shawn Church

Thank you Genevieve! Appreciate the help.

AlMendoza

I opened the attachments in the sheet I want to copy and clicked on the box to choose all documents. Under Actions, I chose to Download file. The system creates a zip folder. I then go to my downloads and copy the contents of the zip file onto another folder. I then went to my new sheet and opened the Attachments feature, clicked on Attach Files to Row XX (your row) and chose them all (I had 30 files) and the system quickly placed them all in the new sheet. Voila! I appreciate being able to do this!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.