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.