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

RGarrels

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

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 https://help.smartsheet.com/function/time

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

Will this work for you?

Kelly