Query Jira without the field name in result

[tal-yechye]

Hello all,

Using JQL on google spreadsheets, If I'd like to get some issue status, what is the way to do it?

For example, if I'd like to get the issue status of xxxx-1234 what I know today to do is:

=JIRA("issue=xxxx-1234", "status")

and I'll get a 1 column table with the header "status" and the status value below:

---------

| status|

---------

|Done  |

---------

How can I get only the value, without the header?

Thanks!

[tal-yechye · Accepted solution]

Found the answer!!!

An example can be:

=index(jira("key = xxxx-1234"),"status"),2,1)

[Jack Brickey]

Hi @tal-yechye ,

I do not understand where you are entering the above equation/query. Can you please elaborate.

[tal-yechye]

Hi Jack, I updated the question but also added the answer :)

Thanks!!