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

[Mike Bagins]

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

[Clark Everson]

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

Best,
Clark