Different timezones and the today function
So, in one of the sheets we are working on, the date for the today function always changes back and forth (a day difference). We think it's because a member of the team has a different timezone so whenever they make changes to the sheet, not relating to the today functions, it changes. We think this because whenever one of the members in our timezone updates the sheet, the date goes back to the right date. Is there a way to make the timezone fixed for the sheet or just make it so that it shows the correct date for both side and stop changing.
Thanks!
Best Answers
-
Hi Wini,
Unfortunately this is a known issue we also have been struggling with a couple of times. It can be another user, but it can also for example be caused by user cell-link@smartsheet.com when you are using linked cells in the sheet.
As far as we have found out it is not possible to define a fixed timezone for a sheet or workspace. We had to solve it in these cases by using a summary field which is updated automatically through the API and set to the correct date value instead of using the TODAY function.
Kind regards,
Peter Harink | 4EF.nl | Consultant & Managing Partner | peter.harink@4ef.nl
-
PS you could off course check the cell history (via right mouse click "view cell history") or look into the "Activity log" and see what exactly causes this behavior
Answers
-
Hi Wini,
Unfortunately this is a known issue we also have been struggling with a couple of times. It can be another user, but it can also for example be caused by user cell-link@smartsheet.com when you are using linked cells in the sheet.
As far as we have found out it is not possible to define a fixed timezone for a sheet or workspace. We had to solve it in these cases by using a summary field which is updated automatically through the API and set to the correct date value instead of using the TODAY function.
Kind regards,
Peter Harink | 4EF.nl | Consultant & Managing Partner | peter.harink@4ef.nl
-
PS you could off course check the cell history (via right mouse click "view cell history") or look into the "Activity log" and see what exactly causes this behavior
-
Hi Peter,
I think it is by user cell-link@smartsheet.com and I had no idea what this means. Can you elaborate on how you fixed it please?
Thank you so much for your help!
-
Hi Wini,
We fixed this with a process running in the cloud and updating just once every day the date. (we've built a small program which uses the Smartsheet API for this)
If you need any help on that just send me an email.
Kind regards,
Peter Harink | 4EF.nl | Consultant & Managing Partner | peter.harink@4ef.nl
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 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
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!