Add Ons and Integrations
Add Ons and Integrations
Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
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)
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
@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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
