How to sumif estimates on specific sub-task types

Michael G_

I'm trying to sum numerical fields on sub-tasks at the parent level if the sub-task is of a particular sub-task type (we've setup new sub-task issue types).

I've managed to setup automation that sums up all sub-tasks regardless of sub-task type, but I need to be able to narrow it down further. Here's the snippet I use for the additional fields:

{
"fields": {
"Sum Back-end Estimates": {{issue.subtasks.Story Points.sum}}
}
}

 I want it to be more like

{
"fields": {
"Sum Back-end Estimates": {{issue.subtasks.Story Points.sumif(issue.subtasks.issueType.name,"Back-end Sub-Task")}}
}
}

Bill Sheboy

Hi @Michael G_ 

There are at least a couple of ways to do this:

1. using JQL to find the subtasks you want (which have the trigger issue as parent), use the lookup issues action to gather and sum the values
2. using an mathematical expression, an iterator on the subtasks, and conditional logic on the issueType, sum the values

I recommend trying the first one.

Kind regards,
Bill