nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

To sum up Original Estimate / Time Spent on Epic level - Automation

Oksana Kolesnyk

Screenshot 2025-05-27 at 14.14.48.png

Hello.

I am trying to set up Jira automation to calculate the total Original Estimate / Time Spent on an Epic, including child issues.

But each time, I get an error notification on different steps.

The last branch I tried with values:

- {{#=}}{{lookupIssues.timeSpent.sum}} + {{issue.timeSpent}} / 3600{{/}}

- {{#=}}{{lookupIssues.time spent.sum}} / 3600 {{/}}

Please, someone, help me set it up.

Also, how to use:

- Σ Original Estimate
- Σ Remaining Estimate
- Σ Time Spent

In automations, I do not have the possibility to choose these fields.

Thanks

Accepted answers

Marc -Devoteam-

Hi @Oksana Kolesnyk

Welcome to the community.

On your second rule, set the branch value to {{lookupIssues}}, as I do think you want to action on each Epic found, correct?

Time tracking has 1 smart values and 2 properties to be used:

{{issue.timetracking}}
Accesses time tracking estimates.

Available properties:

{{issue.timetracking.timespent}} - Returns the amount of time that has been logged on the issue in the Time spent field.
{{issue.timetracking.remainingestimate}} - Returns the value in the Time remaining field.

See also this community post, or search the community. This question has been covered more then once.

https://community.atlassian.com/forums/Automation-questions/Jira-automation-rule-to-sum-up-timeSpent-on-Epic-level/qaq-p/2553250

All comments

Marc -Devoteam-

Hi @Oksana Kolesnyk

Welcome to the community.

On your second rule, set the branch value to {{lookupIssues}}, as I do think you want to action on each Epic found, correct?

Time tracking has 1 smart values and 2 properties to be used:

{{issue.timetracking}}
Accesses time tracking estimates.

Available properties:

{{issue.timetracking.timespent}} - Returns the amount of time that has been logged on the issue in the Time spent field.
{{issue.timetracking.remainingestimate}} - Returns the value in the Time remaining field.

See also this community post, or search the community. This question has been covered more then once.

https://community.atlassian.com/forums/Automation-questions/Jira-automation-rule-to-sum-up-timeSpent-on-Epic-level/qaq-p/2553250

Oksana Kolesnyk

Hello @Marc -Devoteam-
Thank you for the answer

1. Before the Jira UI was updated, I had such automation in a few projects, and it worked. https://community.atlassian.com/forums/Automation-questions/Jira-automation-rule-to-sum-up-timeSpent-on-Epic-level/qaq-p/2553250
However, right now I get an error, and it does not work.
The trigger is Work Logged.

Screenshot 2025-05-30 at 05.50.29.png Screenshot 2025-05-30 at 05.51.35.png

2. I am trying to set the same automation but trigger is Scheduled (for example each 5 minutes). I need to calculate Σ Time spent and Σ Original estimate for closed Epics. On a set up screen, second step it shows me "This component may be incompatible"

Screenshot 2025-05-30 at 05.57.18.png

I have reviewed Forum and tried to copy setting of automations for Σ Time spent and Σ Original estimate. Each time I get some error.

Bill Sheboy

Hi @Oksana Kolesnyk

Just following up to check if this answered your question. If so, please consider marking this one as "answered". That will help others with a similar need find solutions faster. If not, please let the community know what help you need with the rule changes.

I do note an error in the rule you posted where the JQL for the second Lookup Work Items action is incorrect. Did you notice that?

Kind regards,
Bill

Oksana Kolesnyk

Nope. I have not gotten an answer to my question.
My main question is how to set it up through Trigger - Scheduled.

It works for me with the trigger when a work item is updated, etc. (I've fixed JQL mentioned above).
However, when I try to use the same automation but Trigger "Scheduled", I get an error.
How to set up automation for sum thru Trigger "Scheduled"?
Screenshot 2025-06-18 at 14.59.50.png Screenshot 2025-06-18 at 15.01.01.png