Trouble creating Last Modified column using ChangeTimestamp (CSV Upload / UTC Conversion)

[Bean]

Hi Community,

I’m having trouble using the ChangeTimestamp feature in conjunction with CSV uploads.

When uploading or updating a row with import data (csv upload). The datetime is formatted in UTC but as you can see in the USERTZOFFSET() column, records the time zone of the user. Then if a datetime is edited in the Appsheet interface by a user, it tracks the local time of the user with the same USERTZOFFSET() time zone as the user.

The issue is the incompatibility of the two and lack of ability, I’ve found, to convert everything to the same TZ.

Would greatly appreciate any help on this or a work around! Thank you in advance.

[Bean]

Happy to provide more info too if its helpful