When I import data using Jira Cloud for Sheets, what Timezone does it use when you include any type of date/time fields? I've tested this and it's not using my current timezone.
I don't know the precise answer, but properly written software should differentiate between the data and its display.
In this case, I'd expect that times are normalized to a predefined timezone (most software are using UTC), then you can choose the timezone in which you want to display the values.
Hey @Travis Spackman -
I found this older thread that might help:
https://community.atlassian.com/t5/Jira-Service-Management/Jira-Cloud-For-Sheets-exports-data-in-a-different-time-format/qaq-p/1289496
This was a known bug from 2020 and it's unclear to me if it's been resolved. Hopefully this at least points you in the right direction!
It looks like you're new here. Sign in or register to get started.