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 at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
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 at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
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 at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
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 at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
@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 at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives