DataMesh and Attachments

Question for the Hive Mind,

I need advice on the best way to handle a project involving two separate sheets that contain different but overlapping information. Sheet A is for internal data tracking (my team), and Sheet B is for external data tracking (vendors). I want to avoid cluttering Sheet A with unnecessary data and keep fundamental information in Sheet B for external participants (Vendors) to update, such as checkboxes, responses to questions, and dropdowns.

Currently, I'm using DataMesh to map the necessary data from Sheet B to Sheet A while omitting elements like checkboxes not used in Sheet A. However, I'm facing an issue where if attachments are added to Sheet B, they do not transfer to Sheet A.

I would like to hear from others about the best practice solutions for this scenario.

Thanks in advance,

Michael

Find more posts tagged with

Accepted answers

All comments

Kerry St. Thomas

Attachments exist in a different "place" than cell contents. Data in a cell belongs to a …cell (hence the name 😀 ) but an attachment belongs to a row. Data Mesh only focuses on the per-cell context, so it doesn't move attachments. The only way to move the attachment itself is with a Move/Copy row automation. (Of course this will then create an issue where your rows will be duplicated, kind of undermining the idea for Mesh.)

Is it a possibility for you to add a helper column to each sheet called something like "Category" that is ="Internal" on Sheet A, and ="Vendor" on Sheet B… and then create a report from both sheets , and group by those categories? Or what about creating a unified Sheet C that has your index from each sheet, and use Data Mesh from both sheets into it - using Sheets A & B as "raw data"?

Zachary Murray

I was able to create "Data Mesh Pro" in python that moves data between sheets exactly like data mesh but also includes attachments. Going to save our company $5000 every year. :D

I wonder why the smartsheet developers can't do it?

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.