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; } } }

How to Set Due Date Based Off of Original Estimates of All Open Issues

Matt Steadman_pjaqbe

Hi,

I am trying to build an Automation that will set the Due Date of an Issue to be the Sum of the Original Estimates from a JQL Lookup + the Issues own Original Estimate.

I have built an automation and the screenshot is below of what I am trying to achieve to hopefully make it easier to understand.

Using the automation as I have it now comes up with an error that the I need to enter the Due Date field with an actual date format.

I just can't figure out what smart values I actually would need to put into the Due Date Field to set a date based off the JQL Lookup & the Issues own Original Estimate and have it be an actual date.

Any help with this is greatly appreciated! Thank in advance.

Screenshot 2024-10-16 164538.png

Accepted answers

Trudy P Claspill

Hello @Matt Steadman

Refer to this document:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/

You need to use the plusUnit() function to add the Original Estimate information to a date to get a new date for Due date.

What date do you want to use as the base/start date.

All comments

Trudy P Claspill

Hello @Matt Steadman

Refer to this document:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/

You need to use the plusUnit() function to add the Original Estimate information to a date to get a new date for Due date.

What date do you want to use as the base/start date.

Matt Steadman_pjaqbe

I would use the {{now}} date as the base. So it'd be to add the combined JQL Lookup Issues Original Estimates Sum & the Current Issues Original Estimate to {{now}}.

Trudy P Claspill

Are your Original Estimate all in days, or also in hours/minutes? If the sum of the original estimates includes a fraction of a day, do you want the calculation to round up or down?

Instead of using "+" you'll need to use the plus() function.

{{lookupIssues.Original Estimate.sum.plus(issue.Original Estimate)}}

Original Estimates are stored in the database in seconds. If you add that directly to now() that will not take into consideration your working hours per day or working days per week. Do you need the calculation to consider those?

Matt Steadman_pjaqbe

There could be some Original Estimates that are in hours or minutes. I would want the Calculation to round it up. It doesn't need to take into consideration the working hours per day or working days per week, but, if it could that'd be more beneficial.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

automation

jira-automation

cloud-automation