I linked google Sheets to the Atlassian Jira add-on. I use Jira function
=Jira("fixVersion = SM_S140 and issuetype = Bug" , "key, summary")
I am getting the correct rows but the key is only the name of the key not the URL .
If instead of the jira function I use JQL option , I do get the key as url
How can I get the key as URL with Jira function