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.