Automation to send email with completed story points sum at sprint completion

[Bisrat Shebeshe]

Hello,

I recently created an automation to send an email when sprint was completed. The email should include the sum of all story points in the sprint. However, it sent an email with a sum of story points of 0.

Anything I should change to correct this?

Thank you!

[Trudy Claspill · Accepted solution]

Hello @Bisrat Shebeshe 

Welcome to the Atlassian community.

You have not confirmed that your Lookup Issues action actually found any issues. Check the Audit Log for the rule execution. If no issues were found by the lookup action you'll see a message like this:

If no issues are found then you should use a Log action to print the value of the smart value you are using in the JQL to confirm it has the value you expect. 

[Bisrat Shebeshe]

Hi @Trudy Claspill here is the result of the audit log.

It listed the issues found via the look up.

[Trudy Claspill]

Can you show an image of one of those issues, showing the Story Points field has a value?

Can you confirm that the Story Points field is a number field?

[Bisrat Shebeshe]

As you can see here, the story point estimate field is a numeric field and has value. All issues shown on the look up are the same, but some might not have value, does that make the overall sum zero?

[Trudy Claspill]

The problem is that you are referencing the wrong field in the smart value. In the smart value you reference "Story Points" but the field that holds the value is "Story point estimate". Change your smart value to the correct field and you should get the expected result.

[Bisrat Shebeshe]

Thanks a lot. I will let you know how it turns out.

[YY哥]

This forge app might be your choice to get each sprint completion rate by story points.

https://marketplace.atlassian.com/apps/1229698?tab=overview&hosting=cloud