How to get the value of field in Jira via Google Sheets add-on without its header

Anh Le_0ky9io

Hello,

I'm using Jira Google Sheets add-on in Google Sheets to get the value like this:

=JIRA("project = ABC and issueKey = ABC-66", "status")

I will return the result like this:

However, I only need the value (Testing), not their header Status to use it in a Google Sheet function, is there any way to exclude that header?

Bill Sheboy

Hi @Anh Le 

There is an example of getting the data without the header in this write-up:

https://community.atlassian.com/t5/Jira-articles/Try-the-new-Jira-Cloud-add-on-for-Google-Sheets/ba-p/1016436

=INDEX(JIRA("key=ABC-123", "issuekey, status"), 2, 0)

 

Best regards,

Bill