How to find a Jira field value in a sheet range

[tal-yechye]

Hello guys,

Suppose I want to filter my issues according, for example, their fixVersion.

I'd like to have two tables: The first will show issues only of version 1 and the second only with version 2.

So I created a range in the sheet, for example: Z1:Z2 in which I put 1 and 2.

So cell Z1 = 1 and Z2 = 2.

These will be ofcourse update to new versions when needed...

Is there a way to add a boolean condition to the Jira query like 

       ...AND fixVersion is in (Z1:Z2) AND ...

?

I can check each cell in its turn like that:

AND fixVersion = '"&$Z$1&"' OR fixVersion = '"&$Z$2&"' AND

but in case of more versions listed it is ugly...

Thanks!!!

[Bill Sheboy · Accepted solution]

Hi @tal-yechye 

Are you trying this with the Google Sheets or Excel addins?

I have not tried this, and I wonder if you could just use the IN operator with your lookup references, such as: fixVersion IN ( '"&$Z$1&"',  '"&$Z$2&"' )

Kind regards,
Bill

[tal-yechye]

Hi Bill,

Yes it works with IN!

Thanks :)