Google Sheet Add On - Hyperlink i

Aditya Mirza September 25, 2020

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 

1 answer

0 votes
Dave Liao
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 26, 2020

@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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events