Calculate time spent of an issue with Automation for JIRA

Fernando Magallanes
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 3, 2019

Hello, community. 

My team and I would like to know the time of that took from an issue transition to the final status "done" starting from the beginning of a sprint using Automation for Jira. 

I´ve tried several solutions but I was just able to obtain the number of hours starting from the creation of the issue and not from the beginning of the sprint. 

Is this possible using Automation for Jira? 

1 answer

0 votes
Scott Harwood
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 3, 2019


Yes, you can do this with Automation for Jira. Simply add a rule with an issue transitioned trigger (to "done"), then add an action with the calculation done by smart values, e.g


Took {{issue.sprint.startDate.diff(now).businessDays}} business days to complete this


Here is an example that adds a comment after transitioning to done status

Screen Shot 2019-09-04 at 9.59.22 am.png

Hope that helps,


Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events