Automation for custo field to sum original estimate.

Jeffrey_Denton

I'm having trouble trying to get this automation to work:  

 

To ensure that the custom field Total Project Estimate field on an Idea ticket is automatically updated whenever the Original Estimate field of any linked Task or Story is modified. This automation should:

1. Track Time Changes: Monitor changes to the Original Estimate field on Task and Story tickets in the Execution Project.

2. Sum Estimates Across Linked Issues: Sum up the Original Estimates for all Tasks and Stories linked to the Idea via the "is implemented by" or "Implements" link type.

3. Update the Idea Field: Update the Total Project Estimate field on the linked Idea ticket in the Idea Project with the cumulative sum (in hours) of all linked Task/Story estimates.

---

Technical Workflow:

1. Trigger:

   • When the Original Estimate field is updated on a Task or Story in the Execution Project.

2. Branch to Related Issues:

   • Identify the linked Idea ticket using the relationship type "is implemented by" (from the Idea's perspective) or "Implements" (from the Task/Story's perspective).

3. Calculate the Total Estimate:

   • Aggregate the Original Estimates from all linked Task and Story tickets that are connected to the Idea.

4. Update the Idea Field:

   • Update the Total Project Estimate field on the linked Idea ticket with the aggregated total, converted from seconds to hours.

---

Key Considerations:

1. Cross-Project Linking:

   • The automation must handle issues across two projects:
     • The Idea Project (where Ideas are stored).
     • The Execution Project (where Tasks and Stories are created and updated).

2. Link Type Directionality:

   • The relationship between the Idea and the Task/Story must be clearly defined:
     • From the Idea’s perspective: "is implemented by".
     • From the Task/Story’s perspective: "Implements".

3. Field Accessibility:

   • The Total Project Estimate field must be editable on the Idea ticket.
   • The automation actor must have the necessary permissions in both projects.

4. Error Handling:

   • The automation should gracefully handle scenarios where:
     • No linked Idea exists for a Task/Story.
     • The Original Estimate field is missing or blank on certain issues.

---

Example Scenario:

1. An Idea ticket (IDP-1) in the Idea Project is linked to three tickets in the Execution Project:

   • A Task (EP-101) with an Original Estimate of 8 hours.
   • A Story (EP-102) with an Original Estimate of 6 hours.
   • Another Task (EP-103) with an Original Estimate of 4 hours.

2. A user modifies the Original Estimate on EP-102 to 10 hours.

3. The automation triggers and calculates the new total:

   • 8 + 10 + 4 = 22 hours.

4. The Total Project Estimate field on IDP-1 is updated to reflect 22 hours.

---

Automation Rule Structure:

1. Trigger: Field Changed – Original Estimate (Tasks/Stories).
2. Branch: Related Issues – Linked via "Implements" or "is implemented by".
3. Action 1: Create Variable – Aggregate Original Estimates.
4. Action 2: Update Field – Total Project Estimate on the Idea.

 

Here is the automation:

Bill Sheboy

Hi @Jeffrey_Denton 

That rule description / information looks like stuff from a bot / AI-chat.  If it is, please review the community guidelines to identify sources when posting such content: https://community.atlassian.com/t5/custom/page/page-id/rules-of-engagement

 

Back to your questions...

As written, that rule will neither identify the one-and-only-one linked Idea in the JPD project nor will it sum the values.  Both may be solved using the Lookup Issues action.  For example:

• trigger: value changes for time tracking
• condition: issue type is Story or Task
• action: lookup issues, using JQL to find Idea linked to the trigger issue, based upon the link type
• smart values condition: to confirm there is only one Idea
  • first value: {{lookupIssues.size}}
  • condition: equals
  • second value: 1
• branch: on JQL to the single issue with key = {{lookupIssues.first.key}}
  • action: lookup issues, with JQL to gather the issues linked to the Idea with the correct single link type
  • action: edit issue, to sum the field with {{lookupIssues.timetracking.originalEstimateSeconds.sum|0}}

This rule will need multiple-project scope, and so your Jira Site Admin will need to help create the rule.

Kind regards,
Bill