How to pick up earliest date from Child and copy to Parent

Sinisa Glusac

I'm trying to make automation that will choose earliest date from child ticket (start date field) and copy it to Parent ticket start date. 

For instance Parent “Start Date“ = 01.02.2020, Child “Start Date“ = 01.01.2020, Child “Start Date“ = 01.03.2020 → Parent  “Start Date“ = 01.01.2020. 

I've created automation that collecting date from Child and adding to Parent, but it collect just any date,  now it needs to be earliest date. 

If anyone knows some JSON formula or Smart value and wants to share, that would be appreciated. Thank you in advance. 

Current automation looks like this:

Bill Sheboy

Hi @Sinisa Glusac 

To confirm the problem you are trying to solve...you only want the Parent to change to the earlier date if a Child issue has one.  Is that correct?

If so, couldn't you change your advanced compare condition in the branch to:

• first value: {{triggerIssue.Start date}}
• condition: less than
• second value: {{issue.Start date}}

If instead you need the earliest date among all child issues, consider using Lookup Issues instead with JQL.  That will handle the case of an issue changing parent when the dates do not change...and that may required a couple of rules with different triggers: field value changed for Start Date, and issue updated for a change in parent (both the incoming and outgoing parents could need updates).

Kind regards,
Bill