Trying to get subtasks status for all stories in a JIRA report using sheets(JXL)

Tyagi, Abhilasha

Hello Community,

I want to create a report as below where all issues(stories) have same 3 subtasks (Subtask 1, subtask 2 and subtask 3). After some research came to know that JXL is capable of doing this but I have got no success yet. Hence reaching out to the experts for help. Thanks.

 

Issues(Stories)	Subtask 1 status	Subtask 2 status	Subtask 3 status
Story 1	Done	In progress	To-do
Story 2	To do	To do	To do
Story 3	In progress	To do	To do

There would be other columns as well that are needed like status of stories, assignees, labels, latest comments etc.

Hannes Obweger - JXL for Jira

Hi @Tyagi, Abhilasha

this is Hannes from the team behind JXL for Jira - thank you for reaching out! Can I kindly ask you to reach out to us at https://jxl.app/support, so that the team can look into this with you?

Pending a further investigation in our support channel, I think you have two options: 

First, you could view the stories and their sub-tasks in a parent/child hierarchy, like so:

(This is also showing epics, but you don't need to have them in your sheet.)

To do so, simply create a sheet with your relevant issues, and enable the default issue hierarchy. You can add whatever columns you are interested to your sheet.

Second, you can view sub-tasks, or sub-task related information such as the sub-tasks statuses, as columns to your sheet. This is how this could look in action:

To do so, simply add the relevant columns and/or smart columns to your sheet.

I hope this helps! For any further discussion, I'd say let's take this to our support channel!

Thank you,

Best,

Hannes