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.
Best Answer
-
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
Answers
-
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