=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

1 answer

0 votes
Clark Everson
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 31, 2024

Hi @Mike Bagins 

Welcome to community!

All documentation on the google sheet integration can be found here: https://support.atlassian.com/jira-software-cloud/docs/use-jira-cloud-for-sheets/

There is some general QA to troubleshoot through why it isn't working as well. I do also see your hosting environment is unknown, so keep in mind this is only for Jira cloud


Suggest an answer

Log in or Sign up to answer