Request update only if no recent update exists?

Options
smartsweet
smartsweet ✭✭
edited 12/09/19 in Smartsheet Basics

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?Β 

Comments

  • CaseyDuBose
    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
    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.Β