Can I Not Show Header In Google Sheets Integration

[Ron Ganbar]

When using the JIRA() custom function inside a cell to retrieve data from Jira, headers are retrived and displayed as well. For example, in the following function I'm only retrieving the "status" field of a single issue:

=JIRA("key = MYISSUE-1234", "status")

When the function is resolved what gets displayed is the header (Status, in this case) and the value (Closed, in this case).

I would like for the header not to be displayed. Is this at all possible? Something like this:

=JIRA("key = MYISSUE-1234", "status", "header-display=False")

Thanks.

[Earl McCutcheon · Accepted solution]

Hello @Ron Ganbar ,

The data set returned by the "=jira()" command is basically a CSV formatted data export from jira in a similar fashion as if done from the export to CSV option in the issue navigator, so the formatting does not have an option to modify the dat returned data set until after imported to the sheet.

If you're looking for individual values I would recomend setting up a larger data import to a secondary sheet, then use the primary sheet to run your queries to return the values from the secondary data sheet, with something like a vlookup command.

Regards,
Earl

[Ron Ganbar]

Thanks Earl. Works a treat.

[Nicolas Develeer]

Old ticket but the issue remains. 

The solution that I applied to retrieve a single data without the header was to use the INDEX function to retrieve only the second row. 

=index(jira(CONCATENATE("key = ",A2),"status"),2,1)

With this example, you can retrieve only the status for an issue where the key is on cell A2 

[Seraphin Hochart]

When building a roadmap and referencing multiple single tickets, the column title is adding an extra row and having 2 sheets to reference single ticket status across many projects will be hard to maintain

could this be an option in the future?