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

Found the answer!!!

An example can be:

 

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