New Version (1.3) Of Jira Backlog Google Sheet


There is a new version of my Jira Backlog Google Sheet available. It will now handles multi choice fields like labels correctly, and defaults to display name or name fields for fields if they exist.

If you're new to the script you can find out more details here.

/ If you found this post informative, enlightening, entertaining, or it's just helped you solve a problem then please feel free to shout me a coffee for my trouble from extensive menu below:
Today's Menu

Get More Accurate Burndown Chart For Jira

...This worked well until the team decided that they wanted to try using Jira - it worked well for them, but not for me as I had a good setup with the spreadsheet which gave me the exact information I needed, and had the burndown chart working exactly as I wanted - it took into account variations of hours available during the sprint (Some days were meeting heavy for example), which made it much more useful for checking the team's progress, and seeing if corrective action was required...

Read More
/ If you found this post informative, enlightening, entertaining, or it's just helped you solve a problem then please feel free to shout me a coffee for my trouble from extensive menu below:
Today's Menu

Automatically Import Jira Backlog Into Google Spreadsheet

...you can give read-only access to your Jira projects to the whole world (without requiring a login), but you might run into problems if your competitors got hold of the url, so that didn't seem like a great solution.

I therefore decided to use the Jira Rest API to import the backlog into a Google Spreadsheet, which could then be shared with just our organisation...

Read More
/ If you found this post informative, enlightening, entertaining, or it's just helped you solve a problem then please feel free to shout me a coffee for my trouble from extensive menu below:
Today's Menu