sum up story points of open tasks and stories in a custom field of the parent issue

Question

Hello community,
I'm able to sum up all story points of child issues in a custom field in the parent issue. If one of the child issues is pulled into the Done status, I want to get in the Story Point Field of the parent issue only the sum of all Child Issues that are not in the Status Done.
Should I use a JQL smart value ore math. expression?
Best regards
Cornelia

Bill Sheboy · Answer

Hi @c.ermeier

I suggest the answer is: either one will work, using smart values and a math expression...with conditional filtering, or just JQL and the Lookup Issues action.

Without seeing your full rule details, I recommend completely summing the values for the child issues whenever needed to reduce the chance of errors from automation rules not running (e.g., during an outage).

Kind regards,
Bill

Walter Buggenhout · Answer

Hi @c.ermeier,

Isn't it an option to just reduce the value of the parent field's story points field with the number of points on the issue you just moved into the Done column?

Hope this helps!