Does Data Mesh work with a multi-select column? I'm seeing errors with a very simple Data Mesh config.
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).
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)
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.
Hi @Amy Stephenson
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!
@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
How do you get the URL for the Calendar so that others can view. I tried the Open Sheet, but cannot find the "Web Form" anywhere.
I'm creating a workflow to populate a drop-down column with a large number of values. It looks like there is a 100-node limit to the row array being returned. Is this true, and if so, how do you increase this limit?
Dear All: Good morning. We are VERY close to getting the approval from my top management for DataMesh - this is something I have been hoping to get for us since 2019. We were able to help 4 departments set up and become power users of Smartsheet last year. DataMesh will allow easier and faster inter-departmental data…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.