Google Sheet Add On - Hyperlink i

[Aditya Mirza]

I used Add on in Google Spreadsheet, I succeed to query using JQL and then populate the table/data that I want to. (I'm using =JIRA() feature)

But is there any ways to populate data with hyperlinks (links to Jira issue)

For example 

Key: TEST-123 ---> Can it be also populated links to Jira Issue Directly? and accessible from Spreadsheet?

so it will be like this

key: TEST-123

in my spreadsheet

thanks 

[Dave Liao]

@Aditya Mirza - hi Aditya! I don't know offhand if Jira Cloud for Sheets lets you pull URLs (if URI or URL is available in the API, it might be possible...) but in your Google Sheet, you can create a separate column called URL, then use this formula to create URLs:

=CONCATENATE("https://acmecorp.atlassian.net/browse/",A2)

...assuming column A contains your issue keys. Replace acmecorp with your Cloud site.