Using Data Mesh on Template Sheet

Chloe K.

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.

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

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