Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Automation Rule to calculate actual working hours and estimated time

Fathima Nahda
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!
June 24, 2024

 

I'd like to know add automation to calculate difference between original estimate and actual time spent 

1 answer

0 votes
Tommaso Gionfriddo _Teklada_
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.
June 24, 2024

Hi @Fathima Nahda , welcome to the community!

Using maths expressions with smart values is how you can achieve this.

To access the original estimate and time spent, use the following smart values

  • {{issue.timetracking.originalEstimateSeconds}}
  • {{ issue.timetracking.timeSpentSeconds}}

Then subtract the time spent from the original estimate, and find the absolute value of the result via the following

{{#=}}ABS({{issue.timetracking.originalEstimateSeconds}}-{{ issue.timetracking.timeSpentSeconds}}){{/}}

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events