Request update only if no recent update exists?

Am I being dense? I can see ways to automate a reminder based on conditions, but in a sheet with multiple submissions from one person, if I want to remind them ONLY if I haven’t received a recent update, I can’t say “don’t send if.” ?

I can send a request for update based on “if not in the past” but if there is a recent item it sends them the recent item, and that is annoying if they just added that item.

Help?

Find more posts tagged with

Marketing

IT & Operations

Update Requests

Comments

CaseyDuBose

Try this from my screenshot.

Automation runs on a set cadence like daily or every Tues and checks the following criteria.

If the modified date of the row is greater than 10 days old, then it'll send a reminder according to your conditions.

--

Casey DuBose

casey@dubose.haus

Screenshot from 2019-10-08 13-05-40.png

Ella

Interesting suggestion about Modified. However would not that pertain to anything modified in the whole row meaning the whole row needs to not be touched at all for the UR to go out?

Here is my suggestion - if they only need to update some columns, you can set a condition in the UR for these particular columns to be blank. That way if they have completed what they had to do, the request won't get sent.

Sign in to join the conversation!

Quick Links

Trending discussions

SUmmary in Report Widget
How can i create a Report widget that only shows a status with "red status" from my main data source? Do i need to create a separate data source on just my "red status"
Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…