nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I solve this error : "Unknown function: 'JIRA'. "

Ali Basar Demir

Google Sheets Jira adds-on started to give errors today, with the error code "Unknown function: 'JIRA'." Normally, it was working properly but today it gave this error and is fixed after an hour. Right now, it gives the same error, could you help me to find a solution for this ?

Accepted answers

Tinker Fadoua

@Ali Basar Demir

I see that you are a Cloud User, it could be that Atlassian was performing some tests or making changes. Or it could be a glitch happened in Jira.

You mentioned that it resolved by itself but started again. If by tomorrow it is not fixed I can share the link with you so that you can open a support ticket with Atlassian.

Best,

Fadoua

All comments

Tinker Fadoua

@Ali Basar Demir

I see that you are a Cloud User, it could be that Atlassian was performing some tests or making changes. Or it could be a glitch happened in Jira.

You mentioned that it resolved by itself but started again. If by tomorrow it is not fixed I can share the link with you so that you can open a support ticket with Atlassian.

Best,

Fadoua

Ali Basar Demir

@Tinker Fadoua

It is fixed today, thank you so much for your support

Best,

Ali

Tinker Fadoua

@Ali Basar Demir Thank you for accepting my answer! Glad it is working fine today.

Please don't hesitate to reach out if it starts acting up again 🙂

Best,

Fadoua

Alberto García Ramos

This is a recurring problem.

In my case, it happens sometimes when I make a copy of a spreadsheet that uses JIRA plugin.

When I make a copy and then activate the plugin for the new copy, sometimes it doesn't recognise the JIRA function.

I've tried to refresh, rewrite the function in the cell, closing and reopening the spreadsheet and nothing works. I had to delete the spreadsheet, make a new copy and pray so the new copy doesn't have the same problem, because it only happens sometimes.

Best,

Alberto.

Tinker Fadoua

@Alberto García Ramos

Are you a Cloud or Server User?

If server what do you see or your Jira Admin sees on the Application log? Can you please copy and paste the line with the error after hiding any confidential information?

Best,

Fadoua

Carmen Rosa Ussi

Getting same problem as reported by Alberto here. I'm using the Cloud version. I tried to refresh many time and it does not work.

Unknown function JIRA.png

I checked on the console, and there is a recurrent warning. More lines appear when clicking in enter button when the cursor is in that cell.

empty string unknown function JIRA.png

Carmen Rosa Ussi

I created a new Excel file from a previous one and this time I activated first the JIRA function (before modify anything) and everything works smoothly. In the previous one, firstly I modified the file and then activated the JIRA function, and even clearing the cell and writing it back it didn't work anymore. @Tinker Fadoua I hope it would help to solve the problem.

Nathan Huebner

You must be the document owner to enable the =JIRA function.

Having edit permission does not work.

Thanks for your answers, I have to copy the sheet and become the owner to get this working.

Phil_Parker

@Alberto García Ramos @Carmen Rosa Ussi I'm seeing the same issue when copying a Sheet (Jira Cloud). Have you found a workaround? I do not see the error when creating a "new" Sheet and using Jira function(). I get the error only when I copy a Sheet, clear function, enable function, then re-add function..still get error.

Alberto García Ramos

Hi @Phil_Parker ,

Yes, the workaround is just deleting your copy, making another copy of the spreadsheet and hoping it doesn't fail. The error usually doesn't show up if you don't modify the name of the copy of the spreadsheet until you have refreshed the Jira() function.

Since I posted the comment about the problem, there has been an update in the plugin, but the issue is still happening.

I hope this helps.

Max Makhrov

This helped in my case:

delete all JIRA functions from the current file. Deleted "=" at the beginning of the formulas
File > Make a Copy
Go to Jira Addon and > Get issues from Jira > Import type = Jira()
Enable Jira function via add-on
Restore my Jira() function in the sheet, from step 1.

Előd

Hello

The add-on tab works, with JQL issues. But I still got the Error: Unknown function: 'JIRA' as a cloud user. And I would like to use this method.

1) I am the owner of the Sheets file.

2) It is inside one of ours shared drives in our organization.

3) And it is a must use, so I can not copy, move etc it.

4) I am an admin on our JIRA instance.

Thanks for your thoughts

Diego Germán Marchetti

Hello,
This really works!
thank you so much!

Edwin Meijer

Perhaps coincidence, but the same trick (run the query before you rename the copy of the sheet) works.

Steve Iaccheo

This worked for me as well. Thank you @Max Makhrov

Stefan Rotariu_jdu3wf

This has worked for me as well!

Graham A

I was able to resolve this without creting a new copy of the sheet.
Not sure how much is necessary, but this was my process:

Fix the error in my google Apps Script and save it. (I had the Jira=() issue before the code error, so doubt that it's related)
Reload my google sheet using Ctrl-F5 (supposed to reload cached data also, unlike a normal refresh)
Went into Extensions > Jira Cloud for Sheets > Settings & unchecked all (2) permissions and closed the Jira extension 'window'
tested the =Jira() cell to confirm it's disabled before another Ctrl-F5 reload.
Go into Jira Cloud for sheet extension settings and re-enabled the permissions
tested the =jira() cell / function and it worked.

Background: I had copied two different sheets with Jira extension and after enabling the extension and =Jira() option, both copies were returning this error. The originals were not having any issue, so I know this was a problem with my sheet and how it talks to Jira.
I got one sheet to work almost easily with just one or two simple refreshes, but the second one I had to be more methodical about before it began working.

No root cause or access to logs here, but hope the above helps someone.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-core

jira-core-cloud