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
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
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
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.3K Get Help
- 446 Global Discussions
- 144 Industry Talk
- 477 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives