Setting automatic update request based on field data

It looks like the automated update requests need data in the row (or in a column) to change before an update can be requested.

I want to request updates on a given schedule - without having to manually request the update. Here's the situation - we have trainers in the field who create a new class using a form. The classes last several weeks, but we want a status update at the start of the class and at the end of every week.

I have created update request rules that should fire when each of the calculated dates are equal to today - but it looks like if nothing else on that row changes, the request doesn't actually get triggered.

Anyone have other ideas?

Find more posts tagged with

Update Requests

Comments

Eileen OH

I have a similar issue - I want to know when something hasn't been updated. So if it has been 5 days since an update request was sent, and the item still hasn't been updated, I want it to send another update request.

Shesha_K

I have also been looking for a simple solution for sending automated updates without a cell being "triggered". It seems as though there should be an option to simply have a request sent on a daily/weekly/bi-weekly etc. schedule..

J. Craig Williams

What we could really use is the Reminder functionality for the other Alert types. I have my suspicions on why that has not been done (and maybe won't be).

Since we can't trigger without a change to the row, the obvious solution is to change the row.

For recurring tasks, I update the sheet nightly (after midnight) and that causes other things on the Sheet to be updated.

For the Update Request rule, it becomes

Where (Date column) is today.

It is a little more complicated than that, but does not take long to set it up if I've never seen the Sheet before.

Craig

Paul Newcome

An update to this thread... You can now use a Date type column to trigger update requests. So if you want to send an update request 5 days after the submitted date, you could add a Reminder Column and enter the formula

=Submitted + 5

You would then set the Update Request to send on the date in the Reminder Column (and include in additional conditions for complete vs incomplete/checked vs unchecked/etc).

Sign in to join the conversation!

Quick Links

Trending discussions

Document filtered by form responses
I've created a Smartsheets form. When someone submits the form, I want them to automatically be emailed a document that has resources and links, but the document is filtered to only show the content that corresponds with what they selected in the form. Is something like this possible? What types of documents or automations…
Form stopped working after upgrade
I have a sheet that I created in a previous version, and it had a form. I was recently upgraded to a newer version and now my form is not working. I created a new form for the sheet, and it is giving me an error also. Does anyone know what I can do to fix this? The error says Form Unavailable. Sorry, the form you're trying…
Getting Error About Emulated Environments
Hi, I have read the post from 8/21/25. I am still getting the same error. I am setting up a new device and just download the latest version as of 9/5/25. I am using a Eunivon Smart White Board for touchscreen capability. It is running Android 14. Any help would be appreciated.