Jira Cloud for sheets - reference a cell with the project key

[Judah Ferst]

Hi, 

With the new Jira Sloud / Google Sheets integration is it possible to reference a cell with the project Key in it? 

I am using =JIRA("project='"Project_Data!B2"'", "summary, issuekey, priority, reporter, assignee, timeoriginalestimate, timeestimate, timespent, issuetype, customfield_10009, labels, resolution, status, resolutiondate, created, duedate, customfield_11700, fixVersions, customfield_11100, project") where Project_Data!B2 is TPP which is a project key, but I get a formula parse error.

[Tiago Cardoso]

This question seems to be a dup of https://community.atlassian.com/t5/Jira-questions/Changing-background-of-whole-cards-in-Rapid-Boards/qaq-p/163072#U1054112...

Vote for this feature to become native:

https://jira.atlassian.com/browse/JRASERVER-65638

For Chrome there's also a plugin:

Jira Issue Color Extension

[scrumbun]

Seems like Jira is blocking the use of these chrome extensions now to get us to buy the plugins from the marketplace. SHADY JIRA! 

[Thor]

Hi, I am from the company who developed a plugin for this. The app is called "Agile Colors for Jira Software" and you can get it on the marketplace since this week (link).

[scrumbun]

The only thing stopping me from installing this is that it is a global change. I do not want to force all users/projects to have this. 

[Sam]

This plugin looks very helpful! Is there a Cloud version in the works?

[Thor]

Sorry for the late reply.

@scrumbun

Valid point. Thank you for commenting on this!

@Sam 

Thank you. Not at this time but I'll notify people that this is in demand. AFAIK this could be difficult as I understand that Cloud products do not allow this kind of access (addons are more like SaaS to connect with the product). Please correct me if I am wrong.

[Deleted user]

I agree that the header colors aren't very effective and I am looking for a solution to this as well.