How to convert time spent on an issue to actual story points?

[Benjamin Santos]

Howdy and thank you in advance!

Question

• How can I leverage JIRA automation to automate the calculation I detail above and update the Actual Story Points field?

Background

• My team leverages story point estimates per issue (0 = 4hrs, 1 = 8hrs, etc.)
• Currently, I leverage the Time Spent Sum field that displays the number of hours (i.e. 4.27h) spent on the issue.
• Then I extract data to excel, convert time format shown above to a number format (i.e. 4.27) and divide that value by 8 to calculate the "Actual Story Points".
• I have creates a custom field to capture the "Actual Story Points".
• I have tried the automation on my own leveraging calculation functions and the worklog data smart values but, have come up empty many times.

If I can provide any insights, I am happy to do so.

[Benjamin Santos · Accepted solution]

Figured it out.

Aside from trigger configuration, edit the desired field and use the following calculation.

{{#=}}ROUND({{issue.fields.timetracking.timeSpentSeconds}} / 28800, 2) {{/}}