Using Data Mesh on Template Sheet

Hello,

If I set up a Data Mesh on Sheet A and then create a copy of Sheet A by doing "save as new", will the Data Mesh target remain on Sheet A only? Or will it now target Sheet A and Sheet B?

Would it be better to use an Index/Match formula on Sheet A in order to have it carry forward onto Sheet B, C, D, etc.?

I suspect the Control Center function would allow me to do this more easily, but it is not currently an option for me.

Thanks.

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Chloe K.

The new sheet wouldn't be targeted in Data Mesh, you would need to either set up a new workflow with Sheet B as the target or update your current workflow.

Could you maybe explain your process a bit more? The INDEX(MATCH formula is quite useful, but depending on what you need to do there may be other options as well. Any screen captures of example/dummy data would be very helpful!

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Chloe K.

The new sheet wouldn't be targeted in Data Mesh, you would need to either set up a new workflow with Sheet B as the target or update your current workflow.

Cheers,

Genevieve

Adrian Mandile CHESS

Hi @Genevieve P.,

Is there any work around for using DataMesh to link a source Master Data sheet info to a target template version of a Project sheet, that then uses 'Save As New' to create new folders with all the project sheets/reports, etc (Control Center is not a feasible option). Using INDEX/MATCH would be a bit messy because we need the option in the many target sheets to look up (once, for existing data) or input (new data).

Genevieve P.

Hi @Adrian Mandile CHESS

Save As New currently will not create a new DataMesh between two sheets in the same folder. Here's a related Product Idea you could vote on! Duplicate a Datamesh

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.