Help & Support
Send Feedback
JiraReportingInGSheets
Use =jira custom functions in cells to get data via JIRA api, combine with sheet formulas and build graphs.
3 users
Works with
Install
Overview
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:
getJiraIssueFieldsValues(searchQueue, searchFor, showOnlySuchFields) gets 1-dimensional array of issues fields values  returned for the specified JIRA search query.
e.g.: =getJiraIssueFieldsValues( "project in (QAE) and issuetype in (bug)";
"fields.status.name";"status")

Enjoy!

Sincerely yours,
QAEXPERTS.
Please visit the Chrome Web Store if you would like to reply or rate a review for this app.
Reviews
No comments
Additional information
Search
Clear search
Close search
Google apps
Main menu