How to show time in Google Sheets according to your local time zone?
Updated today
Submission times arrive in Google Sheets in the time zone saved on your Youform account, so set your account Timezone to your local time zone to see local times in your sheet. If no time zone is set on the account, Youform sends the time in UTC.
Show local timezone in Google Sheets
The Submitted At value Youform writes to your sheet records when the submission was completed, converted to your account's time zone. It is written as plain text, not as a date the spreadsheet formats itself. The Google Sheets integration has no time zone setting of its own, and Youform does not use the spreadsheet's time zone.
Set your account time zone
Click your profile avatar at the top of the dashboard and open Account Settings.
Open the My Account tab.
In the Timezone field, search by city or region and select your time zone.
Click Save.
Submissions synced to Google Sheets after you save are written in the time zone you selected. Rows already in your sheet keep the time they were written with.
To connect or manage the integration itself, see Connect Google Sheets.