How can i get the sum of of all subtasks except epic and story to parent epic parent using smart val

Mehdi Bouazza

Hi Atlassian community

I want to create an automation that autocalculate sum of all worklog subtasks except Story and Epic and set the sum to parent Epic 

 

issue.childissue.timeSpent.sum get me the sum of all subtasks ,how can add a condition in this smart value ??

{{#=}}{{issue.childissue.timeSpent.sum}} / 60{{/}}

 

Thank you 

Bill Sheboy

Hi @Mehdi Bouazza -- Welcome to the Atlassian Community!

Perhaps try using the Lookup Issues action, with JQL that narrows the issues to just the ones you want.  And then sum the values from the returned issues.

Kind regards,
Bill