How can I change the timezone of google spreadsheet?

  • solodkova.nataly181181
    Asked on November 16, 2016 at 5:48 AM

    Good day! Could you tell me, how can I change the timezone in an integration google spreadsheet? Now I have to add 7 hours to Submission Date.

     

    Jotform Thread 991211 Screenshot
  • amy
    Replied on November 16, 2016 at 7:05 AM

    Hello,

    You can change your timezone by following this way:

    1- Login to your account.

    How can I change the timezone of google spreadsheet? Image 1 Screenshot 60

     

    2- Click on the person looking icon and then click on "Account".

    3- In the account page, click on the "Settings" menu and then click on "edit" button.

    How can I change the timezone of google spreadsheet? Image 2 Screenshot 71

    4- Now you can select your timezone from the dropdown.

    How can I change the timezone of google spreadsheet? Image 3 Screenshot 82

    After applying these steps, you will see that your submissions' timezone has been changed. But to reflect the new timezone on the google spreadsheet, you should remove your integration and then integrate it again.

    How can I change the timezone of google spreadsheet? Image 4 Screenshot 93

    How can I change the timezone of google spreadsheet? Image 5 Screenshot 104

    Your spreadsheet should show you the true timezone for you.

    I hope it helps. If you need further assistance, please let me know.

    Thank you.