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

System
Employee
This discussion was created from comments split from: Exclude weekends and holidays from automation reminders.
Answers
-
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.
- Create a Date column called "Today's Date"
- Create an automation that runs daily in the early AM and captures a date to the "Today's Date" column
- Change your formula to use the Today's Date column instead of TODAY()
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives