Helper Column Not Updating Automatically, Causing Reminders to Trigger Over Weekends

Answers

  • Brian_Richardson
    Brian_Richardson Overachievers Alumni

    The TODAY() function relies on the sheet being changed and saved. Otherwise, it does not update the "today's date" information.

    Not usually an issue if the sheet is accessed normally, but if you need it to work over the weekend when nobody is accessing it, then you may want to change things a bit.

    1. Create a Date column called "Today's Date"
    2. Create an automation that runs daily in the early AM and captures a date to the "Today's Date" column
    3. Change your formula to use the Today's Date column instead of TODAY()

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN