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 · Accepted solution]

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

[Aymeric DE CREMIERS]

Hi Andy, 

Thank you so much, it works perfectly!

Best