Using Jira googlesheets plugin to get a url to an issue

Question

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!

Anna_y44l0z · Answer

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

Anna_y44l0z · Answer

Same here. Any improvement ?

Maciej Morawski · Answer

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.