Automation rule to calculate Start and end based on earliest start and latest end from linked issues

Question

Hi all,

I am looking to create an automation  rule to calculate Start and end time for an issue  based on the earliest start and latest end from linked issues

Issue 1  -> relates to Issue 2 ( Start 1-Aug-24, End 20-Aug-24)

Issue 1 -> relates to Issue 3 ( Start 1-Jul-24, End 10-Aug-24)

From the above example, I want to set Issue1 start to 1-Jul-24 and end to 20-Aug-24

Nagashankar · Answer

Thanks @Bill Sheboy , I will try this out and keep you informed if it helped

Bill Sheboy · Answer

Hi @Nagashankar

I recommend using the Lookup Issues action to gather the linked issues with JQL, and then use the list max and min functions on the date values, respectively:

* https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Lookup-issues
* https://support.atlassian.com/cloud-automation/docs/jira-smart-values-lists/#list.max

For example: {{lookupIssues.Start date.min}}

Kind regards,
Bill