Tanguy Crusson Atlassian Team

hi @Gazza , thanks for the feedback. We're currently working on a way to refresh data - and there is an existing workaround you can use in the meantime. For the ability to create/update issues from Google Sheets: it's in our backlog but we can't make any promises for when it will be ready, as it's relatively tricky to get…

Hi @t.muchai , there isn't currently a way to do that, but it's something we're considering. You can follow this ticket to be notified when we start working on it and when it becomes available: https://jira.atlassian.com/projects/API/issues/API-87

@Andy McCormick thanks for the feedback! This is something we're considering, but there's already a built in function in Google Sheets that enables you to do just that. Check out this spreadsheet in the "remove header row" sheet: For a single issue: =INDEX(JIRA("key=MOB-1", "issuekey, status", 0, 1), 2, 0) For a list of…

@Jannik Ackermand the default is 250, but to return more rows you can use the pagination parameters. There's an example for how to do this in this spreadsheet. In the sheet "large imports" 

If you have the formula there then it should work

@Jannik Ackermand I think that's because you need to update the sheet name in the script (currently it's set to "INPUT"). Also , the cell is "A1".

Hi @Tom Cooper we've been working on changes that would allow you to query the 2 things you just asked for: tying issues to their epic, and sub-tasks to their parent. You can follow these issues to be notified when the features are ready: https://jira.atlassian.com/browse/API-72 https://jira.atlassian.com/browse/API-75…

Hi @Jannik Ackermand @Jordi Guerrero we're working on a data refresh mechanism in the add-on. In the meantime, there's a hack to do it from Google Sheets without having to write a custom script: See this spreadsheet in the "data refresh"…

Thank you @[deleted]that is great feedback. Currently we're focusing on JQL and we already have miles to go to make the solution deal with the wide variety of Jira fields, but we're noting your idea of sprint reporting. By the way we're creating a spreadsheet that shows various scenarios for how to use the JIRA() function…

@[deleted] my apologies I just saw your reply! Yes, the documentation is currently a bit light, we're currently creating a sample spreadsheet with the most popular use cases to make it easier to discover. We don't currently handle some fields really well, for example sprints, but are working on it. for sprints, today you'd…

@Jannik Ackermand we're not sure yet, and we haven't looked at the implications of doing it this way. I created a ticket so you can track this: https://jira.atlassian.com/browse/API-54 

@Jannik Ackermand if you're using the =JIRA() function the behavior can be a bit unpredictable. Most times it will refresh when you close and reopen the spreadsheet, but sometimes the spreadsheet does cache the results and the refresh doesn't happen. Until we ship the button, the following hack works: * leave an empty cell…

@Jannik Ackermand if you run a query from the sidebar it is currently not updated: you need to re-run it to get fresh data. We're currently adding a button to help you refresh all queries in a sheet (whether generated from the sidebar or via the =JIRA() function) in one go. It's top of the list in terms of improvements as,…

@Damon Gaylor yes that is a known issue. We're currently testing a fix for it. You can track the status of the resolution here: https://jira.atlassian.com/projects/API/issues/API-11 

Hi @vidal7 - we don't currently have plans to add support for Jira or Bitbucket Server, first we want to see how popular the extension is on Jira and Bitbucket Cloud (as it's faster for us to experiment there). 

Hi @Jens Rosemeier , We’ve had many requests from Jira users for an integration that is officially supported for Google Sheets. I realize now that we should have gotten in touch earlier to share our plans. I do apologize for the lack of communication on our part so far. You’ve built a great add-on, as shown by the 50k+…

Hi there, if you are using Jira Cloud (Cloud, not Jira Server the hosted version of Jira), you can use the Jira for Google Sheets add-on: https://community.atlassian.com/t5/Agile-articles/Try-the-new-Jira-Cloud-add-on-for-Google-Sheets/ba-p/1016436 We hope that helps!

Hi there, if you are using Jira Cloud (Cloud, not Jira Server the hosted version of Jira), you can use the Jira for Google Sheets add-on: https://community.atlassian.com/t5/Agile-articles/Try-the-new-Jira-Cloud-add-on-for-Google-Sheets/ba-p/1016436 We hope that helps!

Hi there, I know it's a bit late but... if you are using Jira Cloud (Cloud, not Jira Server the hosted version of Jira), you can use the Jira for Google Sheets add-on: https://community.atlassian.com/t5/Agile-articles/Try-the-new-Jira-Cloud-add-on-for-Google-Sheets/ba-p/1016436 We hope that helps!

Hi there, if you are using Jira Cloud (so not Jira Server, the hosted version of Jira), you can use the Jira for Google Sheets add-on: https://community.atlassian.com/t5/Agile-articles/Try-the-new-Jira-Cloud-add-on-for-Google-Sheets/ba-p/1016436 We hope that helps!

Hi all, if you are using Jira Cloud (so not Jira Server, the hosted version of Jira), you can also use this Google Sheets add-on: https://community.atlassian.com/t5/Agile-articles/Try-the-new-Jira-Cloud-add-on-for-Google-Sheets/ba-p/1016436 We hope that helps!

Hi @Johan du Preez this extension is only available for Jira and Bitbucket Cloud today. We don't currently have plans to add support for Server, first we want to see how popular the extension is on Cloud (as it's faster for us to experiment there). 

The new Confluence/HipChat integration described in Using HipChat and Confluence together is only available in Confluence Cloud for now, however we are planning to release it for Confluence Server (Confluence version 5.5 and above) in the very near future, as an update to this Marketplace plugin: HipChat for…

@Charles Love are you using Confluence Cloud, or Server (on-premise installation)?

@Debbie Ryan are you using Confluence Cloud, or Server (on-premise installation)?

Hi Bob, With the latest version of the plugin on the Marketplace, you need to be logged in HipChat (and done the 3LO dance) to be able to see the list of issue mentions in JIRA. You can still see "discussed in X rooms", and the name of the dedicated room, but that's it. Does that suffice in your case?

@Oleksandr Diudiun. @Shawna Schnorr @Paul McGuire @Indre Solodov we just shipped this to JIRA Cloud (it was already available in JIRA Server through the "HipChat for JIRA" plugin in the Marketplace). See Anatoli's response below.

Hi @Shawna Schnorr, no need to vote for it, it's already in flight, and I've seen demos of it!

@Gustaf Sahlstrom if you face an issue moving from the older JIRA integration to the new one, please raise a ticket on help.hipchat.com, providing as much information as you can, and we can help you there. We built it so it happens automatically, but maybe there is a glitch?

@Jason Kelsey you cannot currently map a JIRA project with a private room, but we are planning to release this feature in the near future. I will post an update here when it's out, stay tuned!