Jira Cloud for Sheets - subtasks as rows

[Myles Boyd]

I am trying to use Jira Cloud for Sheets as the source of some reporting.

However, one of the team queried the number of issues it said she worked on.

Looking into it, found it's sub-tasks.

How do I get it to pull sub-tasks thru as a row of their own so I can include them in all the counts, etc?

[Christopher Yen · Accepted solution]

Hi @Myles Boyd ,

Just tried this out in my environment. When you click "Get Issues from Jira" there is an option for selecting Issue Types, I checked sub-task and they were included as their own rows in the sheet

[Myles Boyd]

Ah that might be the issue;  I am doing it with JQL not Basic, there's no option with JQL.

But you did point me in the right direction, thank you.   Added    OR  issuetype = Sub-task    to the JQL.