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; } } }

I want to sum up 'Time logged' against sub-tasks, and update it in the 'Time logged' of the parent

Sehreen Jafry_igi8d6

Hi,

I have been trying to use automation rule in Jira to sum the time-logged against any/every sub-tasks and then add it to the Parent User story's "Time logged".

It seems that the automation rule recognizes the 'Time log' field when I use it as a trigger, but when I want to save the value to it, it just doesn't allow me to find the 'Time logged' field.

Just to be clear, I don't mean the Original estimate or the Remaining estimate fields.

Scenario example:
1. User story : A
- Tasks # 1 (1 hour work logged i.e. Time spent = 1)

- Tasks # 2 (2 hours work logged i.e. Time spent = 2)

- Tasks # 3 (3 hours work logged i.e. Time spent = 3)

So, the rule would update the 'Time spent' field of the "User story: A" as Time spent = 6 h.
automation rul.png

Accepted answers

Mark Segall

Hi @Sehreen Jafry

There are specific triggers/actions for logged work. Try this:

TRIGGER: Work Logged
CONDITION: Your existing condition is fine
BRANCH: Your existing branch is fine
ACTION: Log Work
- Time Spent: {{worklog.timeSpentSeconds}}
- Date Started: {{worklog.started}}

All comments

Mark Segall

Hi @Sehreen Jafry

There are specific triggers/actions for logged work. Try this:

TRIGGER: Work Logged
CONDITION: Your existing condition is fine
BRANCH: Your existing branch is fine
ACTION: Log Work
- Time Spent: {{worklog.timeSpentSeconds}}
- Date Started: {{worklog.started}}

Sehreen Jafry_igi8d6

@Mark Segall ,

I am stuck on the 'ACTION: Log work' step.

Jira isn't allowing me to use the same field 'Time spent' for the user story level.

It allows me to use 'Time spent' update as a trigger, but as you can see in the image above, when I try to find the 'field' in the 'Parent' to place the sum of 'Time spent' of the sub-tasks, I can't find the field.

Can you please guide?

Mark Segall

In your screenshot, you're using the Edit Issue action. You need to change that to the Log Work action.

Sehreen Jafry_igi8d6

@Mark Segall ,

I can't believe that actually worked.

I just have one follow-up question as a newbie to the Jira automation rules.

Question: If I want to build the same rule but this time on the 'Epic' level so that Epic's time logged is the sum of the 'user stories' under it, just like the rule created for user stories reflecting the sum of time logged for their sub-tasks.

What's the best practice? Should I create another rule, which is fired based on this rule's firing? Or, is there another better way?

timspent sum.png

Yong Yang_sxvxir

This rule works for Log Work action when time spent is logged, but how about the update/deletion of alreay logged time? How do we write the automation rule then?

Mark Segall

Hi @Yong Yang - Note the final answer on this. The rule is not required. Jira automatically rolls up time spent so whether you're logging new time or editing a previous entry, the Time Spent field will provide an accurate sum of time spent.

Yatish Madhav

I would like the same. I am working on this automation now ... but agree with @Yong Yang - worklog sync should cover work log added, updated and deleted.

I am thinking of adding a scheduled task that runs through all epics then updates the worklog on them for all their child issues. Not ideal but theoretically this should work. Right?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

agile

time-tracking

atl-gruland

automation

company-managed-projects