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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!