Helper Column Not Updating Automatically, Causing Reminders to Trigger Over Weekends
Answers
-
Andree Stara, et al.
I had already had the idea of a helper column but with my formula. As it was not working, I tried your formula
=NETWORKDAYS(TODAY(), TODAY(), Holidays:Holidays)
although the result was the same, why not try it? But it continued not working, i.e., the automated reminders were still sent over the weekend. Then following my gut feeling, this Saturday I woke up early and opened the sheet. The save file icon lit up, and the helper column was unchecked. I saved it and bingo, the reminders were not sent out. Today (Monday morning) I opened the sheet and the same happened, i.e., the save file icon lit up again, the helper column was checked, and I saved it.
The problem is clear: The helper column does not update in the background, as we would like or thought and thus. Am I missing something else here? A configuration tweak perhaps?
Thank you,
John
-
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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives