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

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

using =jira.jql() in an excel cell Edited

when I use the following in an excel cell, the task pane just says "1 of 1 rows imported. Saving..." and never actually brings back the query result.

=JIRA.JQL("issuekey=QI-695","summary")

I get a momentary #BUSY! message in the cell, then an "Import started at..." message in the cell. That's all.

I'm just trying to insert the Summary field value into the excel cell, not bring back a table or a property for multiple issues.

Edit: I tried this a different way, using a blank workbook and the following was the result, using 4 cells -- the cell I used the formula in, plus the 3 cells below it. This is not what is expected. Why would the 1st 3 rows come back from this usage? It seems poorly implemented if this is what was expected.

Import started at November 14, 2019 2:25 PM by Rob Wickham
1 rows imported in 2 seconds
Summary
Risk management and customer requirements embedded within each process definition

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you