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