How to change the time zone of timestamps in Google Sheets?

How to change the time zone of timestamps in Google Sheets?

If the timestamps displayed in Google Sheets do not match your time zone, you first need to configure your spreadsheet, then refresh the data in Ubiqod for the changes to take effect. Only after that will the timestamps for future entries reflect the local time zone you have set.

To update the time zone in your Google Sheets file, go to File, Settings and Time Zone. Setup your timezone in Google Sheets, and then click on Retrieve Spreadsheet data in Ubiqod.

The instructions are mentionned in the connector:


    Try Ubiqod


    Get 100 free credits to start building with Ubiqod: sign up here

      • Related Articles

      • Track On-Site Attendance with Google Sheets

        This article shows how to implement a simple QR-code-based staff check-in system using the Ubiqod platform and the free Skiply Timesheet app for Google Sheets. Prerequisites A Ubiqod account – You can sign up here and get 100 free Ubiqoins to test. A ...

      • Send Clocking Data To Google Sheets In Real Time (QR codes)

        With Ubiqod, you can track your employees' time on-site using QR codes or IoT. Watch this video to learn how to access this data in real time in Google Sheets. The Ubiqod platform evolves frequently. Don't worry if the interface looks different in ...

      • What is a Dispatch in Ubiqod?

        What is a Dispatch? In the Ubiqod platform, a dispatch enables real-time transmission of data collected from user interactions—such as pressing a connected button, scanning a badge, or submitting a form after scanning a QR code—to third-party ...

      • What is Ubiqod?

        Welcome to Ubiqod – the new way to connect your field staff to your IT systems. Ubiqod provides a simple and efficient way to collect data from the field and integrate it with your preferred software, whether it's a Human Resources Information System ...

      • Available Data and Fields in The Ubiqod Connectors

        Some connectors allow you to select which data will be sent and to which location. For example, the Google Sheets connector enables assigning each column to a specific data field. Available Fields (Alphabetical Order) Account Name Content: The name ...