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
@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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.