Trying to copy excel issuekey to search in JIRA

latt11b May 14, 2021

We are exporting JIRA issues into excel, then after using filters attempting to copy the issuekey columns and paste into a JIRA search but the format is incorrect.

 

Does anyone have a better solution?

 

Right now i have to paste in word and add comma's to every jira number space them correctly and then paste into the jira search.

1 answer

0 votes
Charlie Misonne
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 14, 2021

You will definitely need commas if you want to run a search like key in (ISSUE-1, ISSUE-2, ISSUE-9)

Perhaps you could improve your excel sheet by adding af formula that concatenates all issue keys and adds commas in between. Something like:

=LEFT(CONCAT(A1:A5&",");LEN(CONCAT(A1:A5&","))-1)

Suggest an answer

Log in or Sign up to answer