Update TODAY() function automatically improvements
Hello SS Community,
I have been using the required automation to update my sheets automatically since I am using the TODAY() function on my rows. The current setup I have is to check an unchecked box and vice versa.
Other solutions found here: https://help.smartsheet.com/articles/2482767-automatically-update-today-in-formulas#toc-option-4-use-bridge-to-schedule-a-daily-sheet-save
I found that the instructions on this page work as well however, I did notice a gap in the date solution. If users add rows to the sheet, no date gets populated into the row since a formula cannot be used. I modified the automation and wanted to share this with the community. Basically changing the condition to monitor if the date field is blank or not blank. Regardless of the value, it will always record a date.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!