Automate Original Estimate based on Start Date and End Date

[Jyothi Ravipati]

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.

[Fabian Lim]

Hi @Jyothi Ravipati

Take a look at the smart values date functions: https://support.atlassian.com/jira-software-cloud/docs/smart-values-date-and-time-functions/

{{[date1].diff([date2]).[unit]}}


Returns the amount of time between date1 and date2, in the unit specified. If date2 is earlier than date1, the value returned will be negative. You can combine this with the smart value to return a positive value. 

The units that can be used with this smart value are:

• millis

• seconds

• minutes

• hours

• days

• weeks

• months

• years

• businessDays

[Jyothi Ravipati]

Hi @Fabian Lim 

Thanks for your quick response and I have referred the link that you shared. It is helpful, But I am not getting a clear view that how it should be used in Automation and what triggers need to be used

Could you help me on that Please?

[Fabian Lim]

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

[Jyothi Ravipati]

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

[Mehmet A _Bloompeak_]

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.