Automate Original Estimate based on Start Date and End Date

Question

Hi

I would like to have an Jira Automation rule to update Original Estimate based on Start Date and End Date.

( Original Estimate = Start Date + End Date ) But need to Exclude Weekends.

If start date = 12/8/21 and End date = 16/8/21 , Original estimate needs to be 2d.

Could anyone can help me, I appreciate.

Mehmet A _Bloompeak_ · Answer

Hi @Jyothi Ravipati ,

I do not know how to exclude weekends using automation. However, I can suggest our own solution which reports time passed between status changes excluding weekends and non-working hours.

For that specific need we developed Status Time app. It provides reports on how much time passed in each status. You can group statuses to get the overall resolution time of a ticket.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports by any field(eg. average in progress time by project, average cycle time by issue creation month). And all these are available as gadgets on the dashboard too.

If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.

Jyothi Ravipati · Answer

Hi @Fabian Lim

I have tried Implementing as you said, But I didn't get the result in using the Smart value. Could you share me the screenshot, if you have tried it in your instance Please.

Thank you

Fabian Lim · Answer

It depends on you.

You could use it when the issue is transitioned, field changes values, issue is updated.

I would use field changes values since they could change very often. However, you have to ensure that both fields are always populated.

This is an example: https://youtu.be/60sWD66l19k

Your rule will be:

Trigger: field value changes on start and end dates

Action: edit field original estimates with the smart values