Jira cloud for sheets - missing values

[Anatole Brillion]

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

[Lucas Modzelewski _Lumo_]

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:

1. Look at the issues that show blank Severity in the sheet - do they have a value for this field in Jira?
2. If the field is empty in Jira, then it’s likely not an issue with the data pull, but rather a missing value in the original issue.

If you want to know why it is empty, here some guessess:

• Severity might only be set when a type (UI?UX, Performance etc.) is selected.
• Certain transitions might require the Assignee to choose a Severity, but in some cases, this step is skipped -> eg. tickets moves to different transition.
• If an issue is closed without requiring a Severity update, the field may remain empty.

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.

[Anatole Brillion]

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

[Hannes Obweger - JXL for Jira]

Hi @Anatole Brillion

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

[Hannes Obweger - JXL for Jira]

... 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!