Auto Number / system column ( Time issues)
So I have an auto number / system column to show me created date and time for some form submissions...
However its shows me correct date and time an hour behind ???
I have checked my settings they are set to GMT like they should be, I have a feeling it has not took in Daylight Saving Time ....
Any ideas on how to fix this are welcomed .....
the 'time' part is crucial as these are an escalation forms
Thank you again all :)
Best Answer
-
The System Date columns will display values based on your Personal Settings. Is it possible that instead of general GMT you should be on a daylight savings timezone, such as GMT + 1 (Europe)?
If you select the timezone based on location (e.g. Europe) then it will auto-adjust as Europe changes with daylight savings:
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
The System Date columns will display values based on your Personal Settings. Is it possible that instead of general GMT you should be on a daylight savings timezone, such as GMT + 1 (Europe)?
If you select the timezone based on location (e.g. Europe) then it will auto-adjust as Europe changes with daylight savings:
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
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