Data Mesh - Overriding data on the target sheet
When the lookup value is enter in the target sheet, the data values appear right away. However, if I override one of those data values, will data mesh run again to correct it? I tried testing it, but it seems to allow me to override the data value, and I don't see data mesh running again to revert back to what came from the source sheet.
Best Answer
-
Thank you @Genevieve P. for your response. I have it set to immediately.
I did a test and found that it took about 10 minutes to make the update. I guess I was just too impatient!
Answers
-
That's a configuration setting you can change as needed:
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
-
Thanks for your response! Yes, I have that setting correctly. If there is a different value on the target sheet, the data mesh will overwrite it initially. But if I then go to the target sheet again and change whatever data value that data mesh brought over, it doesn't seem to revert back.
-
What do you have in your "Execution Frequency" set-up?
Changing values in the target sheet won't immediately trigger the DataMesh workflow to run. If you have it set for "1 hour" like the image above, then at the 1 hour mark that's when the target sheet will update again. Does this perhaps explain what you're seeing?
-
Thank you @Genevieve P. for your response. I have it set to immediately.
I did a test and found that it took about 10 minutes to make the update. I guess I was just too impatient!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives