Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How do I get a list of tasks and a count of the number of sub tasks for each?

I need to get a report of how many sub tasks there are for each standard task.  We create sub tasks each time there is an issue reported against a main task.  We are looking to use this to then highlight problem tasks by the number of sub tasks it has.  The more sub tasks, the more problems it has.  I can't find any way or anything obvious to do this.

Can anyone help?

4 answers

One manual, but painless approach to solve this:

  1. Add the column "Sub-tasks" to Issue Navigator
  2. Export your issues to Excel with the Better Excel Exporter
  3. Add a formula which is:
    1. 0 if the Sub-task column is blank
    2. the count of the ',' characters in the Sub-tasks column otherwise
  4. Bingo! 
  5. (You can sort the list, you can create a pivot table or chart to find the extremes, etc.)

(Discl. it is a paid and supported app developed by our team.)

1 vote

Hi, @Haydn Robinson.  As you can probably tell from the other answers, there's no easy way to do what you describe with Jira "out-of-the-box."

Rather than promote yet another marketplace app., what I'd like to do is suggest you learn how to craft the right searches for the right app on the Atlassian Marketplace (although, I am not presuming you don't already know).

This Atlassian Community article, 

How to Evaluate Jira Apps: Advice for Solution-Hunting

talks about how to find the right app.

In your case, I suggest start with "spreadsheet" as your search term. What you describe sounds a lot like what one might do in a spreadsheet-like app designed for Jira.

Make sure you select Jira for "Product" and "Cloud" for hosting type when you search. You also choose how to sort the search results: by review rating, by number sold, etc. And, consider whether your want to filter by apps that are Cloud Fortified

Hope this helps,


Hi @Haydn Robinson

here's another app that you might like: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing and inline-editing all your issues fields, plus a number of "special fields" that aren't natively available. One of these special fields is the "number of sub tasks".

This is how it looks in action:


As you can see above, you can view, sort, and filter by the number of subtasks. You could also group by the number of sub tasks (and for any other field, by the way) and calculate different kinds of "sum ups" across these groups, or even across complex issue hierarchies. Of course you can export your view to Google Sheets or Excel with just one click, if further processing is needed. Disclaimer: I work on JXL :)

Hope this is helpful,



Thanks @Hannes.  I'll have a look at this, could be just what I need!

0 votes
Rahul_RVS_Support Marketplace Partner Jun 02, 2022

Hi @Haydn Robinson 

If you are fine with a mktplace app for a readymade solution, you can try out our add-on

Issue Hierarchy Reports 

The app shows the child tasks count at each hierarchy level as shown below.
You can also generate insights such as:

- View the full Jira Issue Type hierarchy of Linked issues,
Portfolio/Advanced Roadmaps, Epics, and Subtasks up to 10 levels.

- % complete based on time spent and story points at each hierarchy level

- Sum up Time Spent, Org Estimate, Time Rmng, custom number

- Group you results to get more out of the data


Epic Hierarchy - CHildren.PNG

Suggest an answer

Log in or Sign up to answer
Site Admin
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,865 views 37 49
Read article

Community Events

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

Events near you