=Jira() in google Sheet - result without column name ?

Mike Bagins
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 2, 2024

Dear Jira Community,

is someone able to answer me two below questions:

- is it possible to use =Jira() function direct in google sheet cell but without showing column name ?
I`m using the below fomule : =JIRA("project = CUSTDEL AND key IN (CUSTDEL-41221)",,1,1)
and it`s working but I`m receiving my result in two rows. first row with defined in setting column name and second row with my expected result

- is't possible to use a direct reference to a cell in the function ?
something like this: 
=JIRA("project = CUSTDEL AND key IN (A$1)",,1,1)
where A$1 is cell number with my key value (the above function is not working)

thanks in advance for support


0 answers

Suggest an answer

Log in or Sign up to answer