Hi Team, How to set the due date automatically when issue field values set to start date and original estimate that time duedate field set to Startdate + Original estimate. I have done as below for the issue transitioned from open to in progress Step1: Open to In progress here trackingdate is {{#=}}{{issue.timetracking.originalEstimateSeconds}} / (60 * 60 * 8){{/}} here due date is {{issue.Start date.plusBusinessDays(Trackingduedate.asNumber).jiraDate}} But there is no change in the due date and the rule is executing successfully. Please let me know the reason for this Thanks.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Ho to calculate the due date field based on original estimate and start date field values

Charan goud

Hi Team,

How to set the due date automatically when issue field values set to start date and original estimate that time duedate field set to Startdate + Original estimate.

I have done as below for the issue transitioned from open to in progress

Step1:

Open to In progress

Open to inprogress.PNG

here trackingdate is

tracking due date.PNG

{{#=}}{{issue.timetracking.originalEstimateSeconds}} / (60 * 60 * 8){{/}}

here due date is

due date.PNG

{{issue.Start date.plusBusinessDays(Trackingduedate.asNumber).jiraDate}}

But there is no change in the due date and the rule is executing successfully.

Please let me know the reason for this

Thanks.

Accepted answers

Bill Sheboy

Hi @Charan goud

At this time, created variables cannot be used in functions, and so the Due Date remains unchanged. Please see/watch this backlog item for details: https://jira.atlassian.com/browse/JRACLOUD-75659

As a work-around, I suggest doing the math in one step to set to the created variable, and then assign that to Due Date in the edit.

Best regards,

Bill

All comments

Bill Sheboy

Hi @Charan goud

At this time, created variables cannot be used in functions, and so the Due Date remains unchanged. Please see/watch this backlog item for details: https://jira.atlassian.com/browse/JRACLOUD-75659

As a work-around, I suggest doing the math in one step to set to the created variable, and then assign that to Due Date in the edit.

Best regards,

Bill

Zoryana Bohutska _SaaSJet_

Hi @Charan goud

Also, if your team has something like a service-level agreement (SLA) for time KPI, you can try to set SLA Timer using JSM (for support tickets) or one of the apps from Atlassian marketplace (for Jira Software or Jira Core issues).

The tool for the SLA timer will give the target date in the issue custom field based on your individual criteria.

For example, you expect the ToDo-Done flow to be completed in 2 days.
Then, once the issue got ToDo status, the system will calculate the expected date of delivery as today + 2days\

Then according to the target-date, you can choose an automation rule to set the due date.

This solution is not easy but can help.

Regards

Charan goud

Hi @Bill Sheboy ,

Thanks for your support and got clarified this query.

Please let me know how can we add the original estimate field + Start date using the math function.

Is it possible to add both these fields using math expression?

Thanks.

Charan goud

Hi @Zoryana Bohutska _SaaSJet_ ,

Thanks for your support.

We want to add the original estimate time to the start date only. Then we can set the due date automatically when we set the start date and original estimate.

I don't want to add the present date(Now+2days).

Is there any chance to set the date as per the above-mentioend criteria?

Thanks.

Bill Sheboy

Hi @Charan goud

I was suggesting to do all your math together when you try to set Due Date:

{{issue.Start date.plusBusinessDays(issue.timetracking.originalEstimateSeconds.divide(28800))}}

Jennifer Baum

@Bill Sheboy I have tried this and it is setting the due date same as the start date. Here is my automation workflow:

Bill Sheboy

Hi @Jennifer Baum

I suggested some things to try in your other post for this same question here: https://community.atlassian.com/t5/Jira-Software-questions/Automation-to-update-Due-Date-based-on-Start-Date-Original/qaq-p/2179070

Kind regards,
Bill

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

atl-gruland