Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

JIRA.JQL() Function in Excel

Alanis_ Hans
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 17, 2024

I'm having an issue with JIRA and Excel integration.
Here's my JQL:  =JIRA.JQL("project = 'ABC' AND key = '" & A2 & "'", "Status")

TheJQL is set in Excel cell B2. The query checks the status of a specific issue based on the issue key value defined in cell A2.
The data is being pulled correctly, however, when the results are imported into Excel, three extra data rows are added:

  • B2 - Starting Import (Taskpane should be opened) at <date/time> by <user>
  • B3 - 1 rows imported in 1 seconds
  • B4 - Status
  • B5- <Status Value>

As you can see, the Status value is moved to cell B5 instead of staying in B2.
How can I ensure that the status value always appears in cell B2, where my query is?

0 answers

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events