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

[Nagashankar]

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

[Bill Sheboy]

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

[Nagashankar]

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