Today function causing Modified (date) to update every day
I'm using the today function to trigger update requests to once a week.
Unfortunately this seems to be causing my "Last Entry Date" in all rows to always be set to the current day.
Any ideas?
Darrell
Comments
-
Hi Darrel,
There is currently no timestamp function in Smartsheets. Use of Today() will always update to the current day that the sheet is accessed. Today() works great when you are calculating days since, or days until based on the current date that the sheet is accessed.
There are third party solutions for time-stamping like www.zapier.com.
J. Craig Williams's response to this community article highlights how he did it. https://community.smartsheet.com/discussion/insert-time-stamp
I recommend submitting a product enhancement request.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives