Time Zone Changing when forms submitted
Hi, I have created a few workspaces that are grids with the information coming from forms that are submitted every hour. All of my formulas and equations seem to be working correctly but am seeing an issue where the time zone constantly changes back to Pacific time when new forms are submitted (I am on eastern time).
My personal account settings are set to US-Eastern time, and I made sure that anyone accessing the reports are also on eastern time. However, when new forms are submitted, it appears that the entire grid is acting like its on Pacific time again. The first 3 hours of a new day are treated as the previous day.
When I originally created these grids and forms I may have been on pacific time, could that be causing the time zone to change? Is anyone else experiencing a similar problem? I would love any help on this, thank you.
Answers
-
What is the issue this is causing aside from not looking right? Are you running any calculations? Are you wanting to display the correct date? Are you wanting to display the correct time?
-
I am using calculations on the dates and times of the "created" time stamp when forms are submitted. This puts the information from the forms into the correct folders/reports based of the calculated dates and times (daily efficiency/Shift efficiency). Currently the largest issue is that I have efficiency reports that calculate daily/shift efficiency based on the calculated day and time. The first 3 hours of any day are grouped into the previous day because the forms think they are on Pacific time which is an issue
-
Take a look through the thread linked below. I am pretty sure there is a timezone solution tucked away in there that you can adapt. Basically you are going to want to use a formula to pull the date, then evaluate the hour/am/pm and add potentially add 1 to the date along with the needed number of hours to the time.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!