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?

Thanks

[Ian Flynn · Accepted solution]

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

[Ian Flynn]

.

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

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

[Ian Flynn]

@Jack Brickey I figured it out, I simply needed to expand the fields to include what is in the ticket (Description etc)

Thanks for your help.