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.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives