Using Jira googlesheets plugin to get a url to an issue

Daniel Crowley October 10, 2019

We've got a Google Sheet with clients requirements.
As an initial review I add an issuekey to the sheet to map to an internal requirement.
I'm the using the Jira google sheet plugin to get the status of the issue.
All of this works fine.

I'm also wanting to link to that issue, but everything returned by the plugin is plain text and not a hyperlink. Is there anyway to add this?

Thanks in advance!

2 answers

0 votes
Anna
Contributor
December 2, 2024

Same here. Any improvement ? 

Anna
Contributor
December 2, 2024

Workaround: 

=IF(B4="";"";LIEN_HYPERTEXTE(CONCATENER("https://[name of your instance].atlassian.net/browse/";B4);B4))

 

Where B4 in my case is the Key of my issue

0 votes
Maciej Morawski
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!
March 5, 2020

Hey, any update on this? I've got the same issue. 

If I choose import type JQL then it's ok, but if I choose Jira() then I received the plain text. 

Suggest an answer

Log in or Sign up to answer