nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira Cloud > Google Sheets > Display "Key" / Ticket information

Ian Flynn

Hi,

When exporting an issue from Jira to Google Sheets, all fields display correctly "Issue Type, Summary" etc.

However the "Key" field creates a link to the issue in Jira, is there a way for the contents of the "Key" to be displayed in google sheets alongside the other fields?

Jira - test.png

Thanks

Accepted answers

Ian Flynn

Create additional fields when pulling the issue from jira, these fields will mirror what is contained in the ticket. "Description etc."

All comments

Jack Brickey

Hi @Ian Flynn , if you are asking to display the key without the hyperlink you can simple remove this by highlighting the column and remove the link. At least I ca do so in Excel and expect the same in Sheets.

Ian Flynn

Thanks Jack - I'm actually looking for the contents of the the key to display.

The key in the above picture is a hyperlink to a ticket in Jira, is it possible to pull in the data from the ticket?

Jack Brickey

When you export filter results it includes the data fields for each issue in the list. You have an option to export only the data shown on the screen or all data fields for each issue. I apologize if I'm not understanding question here.

Ian Flynn

Here are the steps I take:

Jira Cloud for Sheets
Get Issues from Jira
Import type basic
The issue is imported to google sheets from jira
The key (Ian-2) links to the ticket, is it possible to export the data that is in that ticket alongside the other fields?

Screenshot 2024-12-19 163725.png

Ian Flynn

Create additional fields when pulling the issue from jira, these fields will mirror what is contained in the ticket. "Description etc."

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud