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

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