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 ?
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.
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.
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. @Fadoua I hope it would help to solve the problem.
@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.
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.
This helped in my case:
I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event