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