How to retrieve JIRA issues from several projects in Google Sheets ?

Aymeric DE CREMIERS

Hello

I'm using Jira Cloud for Sheets (in Google Sheets), and I'm striving to retrieve issues from several projects in parallel.

Ex: in order to retrieve issues from ProjectA, I would run for example:

=JIRA("project=ProjectA AND status=""DONE""", “issuekey, summary, status, assignee.emailAddress, labels, mycustomfield”)

 

Now what if I would like to retrieve issues from both ProjectA and ProjectB?

Thanks in advance for your precious expertise!

Andy Heinzer

Hi

I understand that you are using Jira Cloud for Sheets app, and want to be able to pull issues from two projects in the same query.  You could do this in two different ways:

=JIRA("(project=ProjectA OR project=ProjectB) AND status=DONE", "issuekey, summary, status, assignee.emailAddress, labels, mycustomfield")

or

=JIRA("project in (ProjectA, ProjectB) AND status=DONE", "issuekey, summary, status, assignee.emailAddress, labels, mycustomfield")

Either way, both are valid JQL in order to pull these issues into the google sheet using the =Jira() function.

Let me know if that helps.

Andy