Troubleshooting: How Smartsheet handles time zones

Applies to

  • Pro
  • Business
  • Enterprise

When you set up your Smartsheet account, you can change your time zone in Account > Personal Settings > Settings> Time Zone

But if your account is set up via sharing -- someone shares an object with you and you respond to an email asking you to create an account -- the time zone is set to the time zone from whence the request originated. If you’re not in the same time zone as the person who initiated the sharing request, you can reset the time zone in Personal Settings. Learn how in this article

Time zones and sheets

Smartsheet may change the time zone of a shared sheet if someone from a different time zone makes changes to that sheet. Sheets adopt the time zone of the last person to access that sheet; simply viewing the sheet is enough to change the time zone. 

Time zones and system columns

System Columns always use UTC in the back-end while the display value matches the time zone of the last person to access the sheet. This means that although the display value is in the sheet-viewers time zone, formulas and API calls using System Column data may be returned based on the UTC time zone.

Pacific Time overrides

When changes are made to a sheet via automation, cell links, or cross sheet formulas, the whole sheet is converted to Pacific Time. Automations services are hosted by service users with a Pacific Time setting. This means that TODAY() formulas and display system column display values may get updated if you are in a different time zone.