Hello, i am using Jira Cloud for Sheets integration to analyse some data happening on Jira.
I have some issues which are missing a fields set in the integration. Not all of them
Severity in this screenshot, is supposed to come from jira tickets. Some of them are not defined in the spreadsheet, while the setting is being defined in the ticket itself
Hi @Anatole Brillion , welcome to the Atlassian Community!
Based on the screenshot, Severity is being pulled from Jira and includes values such as Low, Medium, and High. If these are the only possible values, then the field is being correctly retrieved. However, if some values (e.g., "Extreme Armageddon") exist in Jira but are not appearing in the sheet, there might be an issue with how that value is being fetched.
Before assuming a bug, double-check the Jira data:
If you want to know why it is empty, here some guessess:
Check Jira issues, talk to the team/admin and verify the workflows.
If it turns out to be a data issue (e.g., Jira shows the value, but the sheet doesn’t), report a bug to Atlassian with evidence showing the discrepancy.
Hello @Lucas Modzelewski _Lumo_ , thanks for your prompt reply !
1/ Yes the issues that are showing a blank severity in the sheet have a proper value in Jira field
Severity can be set for all types, with no restriction. We have no automation/field being filled in an automated way, i have double check, and really don't understand those missing field.
I'll report a bug to Atlassian as you suggested ! Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
interesting - did you hear anything back from Atlassian already?
Also, just to put it out there in case it is interesting: If you're open to solutions from the Atlassian Marketplace, there's a number of apps available that either provide advanced exporting capabilities, and/or bring Excel-like interactions and features straight to Jira. I myself happen to work on an app that does both; I'll add more information below.
Best,
Hannes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
... and to expand on my last point: If you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.
JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a range of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.
This is how it looks in action:
This all happens directly in Jira, on live Jira data - so there's no need to sync back and forth between Jira and Excel. If you still prefer to work in Excel, you can also copy/paste data from Excel straight into JXL, and vice versa. Of course, you can also export your data to Excel in just two clicks.
Any questions just let me know!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.