Random Data showing up when using Data Mesh
I have Data Mesh set up to put in a "Type 2" for a loan type when the "Type" is put in. After copying and pasting the data that shows the "Type" of loan, the "Type 2" is automatically updated and also extra data is automatically put in when it shouldn't be at the bottom of the sheet. In the image below, the data that lists the Open Date, Loan ID, etc is what we put in the sheet. The rows that show only Type, the system automatically updated when it shouldn't have. It didn't start doing this until we started using data mesh on the sheet. Any ideas on why and how to fix this?
Best Answer
-
It sounds like the mapping for your DataMesh is incorrect for what you want it to do. Would you be able to post screen captures of your DataMesh workflow set-up?
For example, if you wanted "Type" to be the original Lookup Value, make sure you don't have it in any of the Data Fields afterwards (to prevent any overwriting in that column).
Then it will bring over Data Field 1 into your other column based on that lookup value.
It also sounds like you have "Yes" selected for "Overwrite Existing Data in Target Sheet(s)"
If you only want the cells to populate in your "Type 2" column if they're blank, you can change this to "No". You could also adjust the Data Mapping Format to be a Cell Link so if the source is updated it will be reflected in this other sheet.
See: DataMesh Details in the Help Center
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
It sounds like the mapping for your DataMesh is incorrect for what you want it to do. Would you be able to post screen captures of your DataMesh workflow set-up?
For example, if you wanted "Type" to be the original Lookup Value, make sure you don't have it in any of the Data Fields afterwards (to prevent any overwriting in that column).
Then it will bring over Data Field 1 into your other column based on that lookup value.
It also sounds like you have "Yes" selected for "Overwrite Existing Data in Target Sheet(s)"
If you only want the cells to populate in your "Type 2" column if they're blank, you can change this to "No". You could also adjust the Data Mapping Format to be a Cell Link so if the source is updated it will be reflected in this other sheet.
See: DataMesh Details in the Help Center
Cheers,
Genevieve
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.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives