Update main issue date fields based on related child issues same dates

[Mohamed Ramadan]

I've 5 child issues linked to main issue, these childs have "start dev date" and "End dev date" CF.

I need when the main issue moved to specific status then to copy the minimum "start dev date" and the maximum "End dev date" from these childs.

How can I do this?

Regards,

[Manoj Kumar Gangwar]

Hi @Mohamed Ramadan you can create an automation like below. 

1. **Trigger:**

   - Set the **Trigger** as **Issue Transitioned**.

     - Configure this to trigger when the main issue moves to the specific status (e.g., "In Progress" or "Ready for Review").

2. **Branch Rule/Related Issues:**

   - Add a **Branch Rule** with **For Linked Issues** (assuming the child issues are linked to the main issue).

     - Select **type of link** (e.g., "is blocked by" or "has child").

3. **Advanced Compare Dates in Branch:**

   - Use the advanced condition to find the **minimum Start Dev Date** and **maximum End Dev Date** from the child issues:

     - For the minimum "Start Dev Date": Add an advanced condition like:

       ```json

       {{issue.Start Dev Date}} < {{triggerIssue.Start Dev Date}}

       ```

     - For the maximum "End Dev Date": Add an advanced condition like:

       ```json

       {{issue.End Dev Date}} > {{triggerIssue.End Dev Date}}

       ```

4. **Action to Edit Main Issue:**

   - After identifying the minimum and maximum dates, use the **Edit Issue** action to set the main issue’s fields:

     - Set **Start Dev Date** to the minimum from the child issues using the smart value:

       ```json

       {{lookupIssues.Start Dev Date.min}}

       ```

     - Set **End Dev Date** to the maximum from the child issues using:

       ```json

       {{lookupIssues.End Dev Date.max}}

       ```

5. **Test and Refine:**

   - Save and test the rule to ensure it works correctly when transitioning the main issue.