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 ?

[Nic Brough -Adaptavist- · Accepted solution]

Yes.

(That was an easy answer - I can't even pad it beyond "you'll need a 10 user licence for each production server".  So , yes, what you said)

[Jim C.]

I would like to add to what Nic said, and that you can find how JIRA is licensed in this FAQ.

[J]

I read the FAQ, but I wasn't sure if number of active users meant user per instance and not per company/institution. Thanks for clarifying that.

[Jim C.]

Hi John, it's users per instance. We're happy to help.

[K N V S S N Murthy]

Im wondering that, is there any possibility that one user in JIRA (j1.mycompany.com) may authenticate with another JIRA instance (j2.mycompany.com). If so how the licence effects

[Nic Brough -Adaptavist-]

You can set up one JIRA to use the other JIRA's user data.

Both systems will need their own licences (e.g. if you have 45 users, you will need 2 50-user licences)

[K N V S S N Murthy]

Ok, can i refer the issue in one JIRA to another JIRA instance.

[Nic Brough -Adaptavist-]

The basic way to do that is to set up an application link between the two JIRA systems and use the "link issue to url" links in each one to provide the cross reference.  This will be just a link though, it won't do anything other than tell the users that there's an issue in the other system (with the url of course)

[K N V S S N Murthy]

Ok,