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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

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

1 answer

1 vote
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Oct 22, 2021

@Rob Wickham , just looking to clean up old issues. Is this stigma question for you or did you find the answer?

I stopped using it altogether because it didn't feel ready for prime time. Has the code improved in the last 2 years?

Found myself looking for an answer to this and arrived here - still seems to be the same, i.e. 3 additional/unwanted/useless rows output - what is the point of these?!

Like # people like this

The sharepoint which is supposed to be pointing to the documentation/examples no longer exists.

It's definitely been implemented with the expectation of returning a table of results, rather than a single field for a single entry. I see two ways to get round this...

  1. Put your =JIRA.JQL("issuekey=QI-695","summary") cell someplace off screen, then reference the cell two rows below that from wherever you want the Summary field to be displayed.

  2. Could you structure your spreadsheet in such a way that you could hide the introductory rows? They'd be there, but not shown.

Suggest an answer

Log in or Sign up to answer