This is new as of the week of January 20, 2025.
1. In a Google Sheet, go to Extensions > Jira Cloud for Sheets > Open
2. Click "Get Issues from Jira"
3. In the Issues tab, use JQL in a query that will pull in a set of issues, and include in the query that the issues are to be sorted by a custom field. For example, "ORDER By cf[12345]" should be at the end.
4. Click "Refresh Issues" or "Get Issues Now"
5. Observe the sort order of the issues which populate the sheet
I would expect that the issues will populate the sheet sorted by the custom field indicated in the JQL. Instead, issues appear to be sorted by the first non-custom field.
If you instead include in the JQL "ORDER By Components ASC" or any other non-custom field, then the issues will populate correctly according to that field.
This may be related to Bug API-280 but I am 100% sure that it is not a duplicate of that.
