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.
Hi @Judah Ferst ,
You should be able to use the google sheet built-in function CONCAT to achieve this.
For example I used the following query successfully:
To get a new list of issues from another project, I can either change the formula above and replace $C9 with something else, or change the cell contents of C9 itself.
Thanks for trying out this add-on and let us know if you have any further questions.
This was a great hint, however, I found a problem at least in what I am trying to achieve which is related to this: I am looking to get all linked issues from an specific issue.
So, I am doing the following:
This will not work, at least not the way I want because it in fact will try to look the actual linkedIssues for the value I have in cell A2, however, it will try to list down so I can simply get the value in order to repeat the same formula recursively down to get each one of the values correspondent to each of the records.
An image might illustrate better what I mean:
Notice the "Key" on each of the columns headers are automatically generated by the actual JIRA functionality.
Hi community 👋, as every Monday we're bringing you a quick update on what happened in the Atlassian ecosystem last week. There were a few interesting events like for example the announcement of th...
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
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events