Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Jira cloud for sheets - missing values

Anatole Brillion
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 17, 2025

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

 

Capture d’écran 2025-02-17 à 16.34.46.png

2 answers

Suggest an answer

Log in or Sign up to answer
1 vote
Lucas Modzelewski _Lumo_
Atlassian Partner
February 17, 2025

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
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 18, 2025

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

 

0 votes
Hannes Obweger - JXL for Jira
Atlassian Partner
February 24, 2025

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
Atlassian Partner
February 24, 2025

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

jxl-basics-v2.gif

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!

DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events