Jira Reporting In Sheets

Use jiraGet custom functions to get data via JIRA api, combine with sheet formulas and build graphs. Generate reports from templates using Templates option in the add-on menu, update your project keys, team members, sprint & board IDs to start it up. Use constructor functions: getJiraIssueFieldsValuesForJQL(searchQueue, searchFor) gets 1-dimensional array of issues fields values returned for the specified JIRA search query. e.g.: =getJiraIssueFieldsValuesForJQL( "project in (QAE) and issuetype in (bug)","status") Enjoy! Sincerely yours, QAEXPERTS.