Data Mesh with mult-select
Does Data Mesh work with a multi-select column? I'm seeing errors with a very simple Data Mesh config.
Best Answer
-
Hi Tana,
Yes, Data Mesh works when using multi-select columns, however both the source sheet and destination sheet need to have the same column type (both need to be set up as multi-select).
What errors are you receiving, can you post screen captures of it? It would also be helpful to see your two sheets and the Data Mesh configuration. That said, it sounds like this may be a question you'll want to ask Smartsheet Support (click here for how to contact Support).
Thanks!
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Answers
-
Hi Tana,
Yes, Data Mesh works when using multi-select columns, however both the source sheet and destination sheet need to have the same column type (both need to be set up as multi-select).
What errors are you receiving, can you post screen captures of it? It would also be helpful to see your two sheets and the Data Mesh configuration. That said, it sounds like this may be a question you'll want to ask Smartsheet Support (click here for how to contact Support).
Thanks!
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
Thank you, Genevieve! This helped and it was a different issue plaguing my Data Mesh workflow. I'm glad I was able to rule this out.
-
can I know how to do that, I am trying to do that but did not see any option
-
Hi @Lakshman .
Can you provide a little more information? What are you looking to do, and can you post screen captures of it? It would be helpful to see your two sheets and the Data Mesh configuration that you have currently set up (but please block out any sensitive data)
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
Hi @Genevieve P
I am trying to use Data Mesh to update a single select drop down. I want to be able to make updates to the source sheet drop down and push those changes to the single select drop down on my target sheet.
-
Data Mesh can help you with that, however keep in mind that it will update the value appearing in the cells in the target sheet (versus adjusting the values in the Column Properties that show up in the drop-down list). Is this what you meant?
Let me know if you have a specific question or issue in regards to your Data Mesh and I'm happy to help!
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
@Genevieve P is there any way to have Datamesh actually update the values in the Column Properties?
-
Hi @Geoff Baker
No; the functionality you're describing can be done by using a different Premium Application, Data Shuttle (versus DataMesh).
See the action that you can select in Step 3, here: Create an Upload Workflow in Data Shuttle
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.2K Get Help
- 445 Global Discussions
- 142 Industry Talk
- 473 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives