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
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives