Welcome!

DataMesh Timing Frequency

I am building a report for a client to show the changes of a status from week to week. My plan is to have (3) columns - the first column will be a live link to the client's status. The second column will be a DataMesh run weekly that will copy from the client worksheet to my worksheet. The third column will DataMesh weekly the second column on my worksheet to the third column on my worksheet. This way we can track current vs. 1 week vs. 2 week.

My only concern is that I can't configure a TIME for the DataMesh. And if the "client to column 2" DataMesh runs before the "column 2 to column 3", it would ruin the column 3 (as it would then be the same as column 2). So is there any way to time the DataMesh so that one runs 30 minutes or so after another, or is it totally arbitrary what time the DataMesh runs?

Thanks for any help!

Find more posts tagged with

Comments

Anthony M.

Hello,

Thank you for your question. I'm happy to shed some additional light on this scenario.

We actually recommend only having one Data Mesh configuration run per unique target sheet to prevent issues. As you mentioned, if mesh B runs before mesh A, it will not work as expected. Additionally, you may also run into API token issues regarding a single sheet attempting to be updated by two different API calls using the same toke at the same time. This will cause an error on the backend and will also not work as expected.

At this time, the only update intervals are those listed in the update frequency drop-down and you are unable to specify a time. If the source for your mesh is a sheet, you may try setting mesh A to update immediately and have mesh B update at least hourly or, from the sounds of your scenario, weekly may be a possible option. This should keep any possible interference to a minimum.

Alternatively, you may also choose to set mesh B to be a manual update. This does take a little bit of time on your end but gives you complete control of the update to ensure everything updates as expected.

That being said, I'm also happy to file an enhancement request with out product team for adding support for updating at a specified time, rather than the set intervals.

Thank you for your time. Please feel free to reach out to our support team(https://help.smartsheet.com/contact), should you have any additional questions or concerns. We are more than happy to help!

Kind Regards,

Anthony

Smartsheet Support

maberry34826

I would like to add a vote for scheduling DataMesh

Alta

I set the frequency of my configuration to 1 day in the hope of it running daily. It didnt. It ran when I manually ran it but not again after that. What am I doing wrong?

jvalz

Hey Jason -

I would add a middle smartsheet to overcome the challenge.

Client Sheet → Target Sheet
Target Sheet → Middle Sheet → Target Sheet

Set your first data mesh from Client Sheet to Target Sheet weekly.

Put an automation on Target Sheet so that when it changes, it copies/updates values in Middle Sheet. Then, put a data mesh from Middle Sheet back to Target Sheet. I've used this pattern with success on similar issues. Hopefully helpful!

Marlana K.

@Anthony M. Could you provide a better explanation of the 12 hours execution frequency?

My assumption is if I manually run this say at 8 AM ET and the execution is 12 hours it would run at 8 PM ET then again at 8 AM the next morning and so forth. Here is my scenario below.

We have a daily process that runs at 5:05 & 5:40 AM ET - clearing our Pharmacy Site Information and repopulating it from our database using an API. Our Pharmacy List is ever changing with management changes, openings, and/or closings of Pharmacies. This sheet feeds hundreds if not thousands of other sheets through index match. Over the last year we have had several instances where the API has failed to run, or has not completed successfully, leaving either a blank sheet or partially populated sheet. Our most recent being this week.

Our process for failed runs is to pull the latest back up, upload the excel file to a "staging sheet" do all the "fixes" for the numbers so the index match will work once we push it into the actual sheet. Takes me several hours to do this since we have nearly 775 pharmacies and it contains stale data since backups only run weekly.

I am updating that process now that we have Data Mesh. I have set up a Data Mesh to create an actual replica of the sheet this way we will have an up to date copy at the end of the day in the event of a failed run. However, if I use this option and the API wipes data and does not repopulate I stand the chance of it also wiping the data from the backup copy due to time of execution setting.

I want to ensure that if I do a manual run at a specific time to "set in" a time that it will use that to determine the 12 hour mark.

Sign in to join the conversation!

Quick Links

Trending discussions

Update Request Expires - Can We Change This
Hello, Our Task Tracker sheet is used to manage and collaborate on internal tasks. Each team member received a daily email containing all tasks assigned to them, and we all LOVE the update request feature where we use a webpage that resembles a form to review & update each request, click next, go through all tasks, and…
New to Smartsheet and completely overwhelmed - how do I manage trials with multiple tasks?
This is what I would like to accomplish using Smartsheets but I am struggling to find the best way to go about it. Each year we get new vegetable varieties that we need to test in various locations at different times. I would like a tool that I can follow each variety up with a grower. The following data is added:…
Update Requests
Hi everyone, In my Supplier Complaint Tracker, we have a situation where it is one supplier, but 3 different non-conforming material complaints. I have those broken up into 3 rows but it is the same supplier. Is there a way to send an update request to one supplier for all 3 complaints at the same time? Thanks in advance,…