Calculate time spent of an issue with Automation for JIRA

[Fernando Magallanes]

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? 

[Scott Harwood]

Hi,

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

Hope that helps,

Scott.