Alert Someone Workflow

Hello,

I would like to setup an alert where someone hasnt updated a cell for 14 days, based on the cell history



Does anyone have any tips?

Regards

Answers

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

    Hi @Rory K Power

    I hope you're well and safe!

    Unfortunately, it's not possible now to reference the cell history, but it's an excellent idea!

    Please submit an Enhancement Request when you have a moment.

    Here's a possible workaround or workarounds

    • Try something like this.
      • Workflow with the record a date feature and helper columns. When the cell gets updated or a specific value is added you'd record the date in one column, and then when it changes you record it again in the same column or another, and then you'd have the alert trigger from them if the date is older than 14 days.

    Make sense?

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

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

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.