System Column - Last Modified

lisarae723
lisarae723 ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi everyone!

Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified" 

Here's the problem: If someone only "views" the sheet & doesn't make any updates, every single row in the sheet updates as if it were modified. 

Any feedback would be greatly appreciated!

Thank you!

Lisa

Screen Shot 2019-12-04 at 11.36.45 AM.png

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Are you using the TODAY() function in a formula in all of those rows?

    thinkspi.com

  • lisarae723
    lisarae723 ✭✭✭✭✭✭

    Ahh... yes, I am. That's the culprit:) I knew there was something within the sheet causing chaos!

    Any thoughts on a work around?                                                                                                              

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Here is my suggestion...

     

    Approver column is Contact type.

    Add Date type column.

     

    Change workflow from Approval to Update Request and send the contact and date columns. Approver enters their name and the approval date.

     

    Set workflow to run based on the submission date column being 10 days in the past with a condition of the approval date column being blank.

    thinkspi.com

  • lisarae723
    lisarae723 ✭✭✭✭✭✭

    Thank you for the suggestion!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help! yes

     

    Let us know how it works out for you.

    thinkspi.com

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Lisa,

    Another option could be the third-party service, Zapier. It's an excellent option for this scenario. Is that an option for you?

    I hope that helps!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    work-bold

     

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Help Article Resources