Is there an easy way to adjust the timezone on a "created date" column?

There is a sheet with webform that my team uses for task requests that has a "created date" column. The date/time is automatic, and 3 hours behind our actual timezone.

Is there an easy way to adjust this?


  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    edited 02/23/24

    Hey @RGarrels

    There's a straight-forward work-around that may work for you using the Record Date Automation.

    Create a helper DATE column. I typically call the column Local Created Date as it will be in Local Date. You will also need a Time Helper column if the Time portion of the timestamp is important.

    The time shown in the Created date should be local time. To bring that time into a helper column, see this article

    =TIME(RIGHT(Created@row, 8))

    Will this work for you?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!