Automation to send email notification when logged hours>=estimated time ONLY when there's estimate?

[Carson]

Hi,

I am looking to create some sort of automation where I can receive an email whenever the time that is logged on an issue exceeds the time allotment in the original estimate/remaining estimate field but only when there was an estimate on a select issue prior to the time that the work was logged.

For example, some issues that my team works on we do not directly assign a time limit to, but we still want to be able to track how long it took. Therefore, they don't place an estimate on this issue but they will still log hours depending on the time that it took them to resolve the issue.

Is there a way that we can capture through an email or some other measure when the logged time exceeds the allotment only when there was actually an estimate established prior to the worklog? I have attached the current Jira automation that I have created and it works in that it will send an email if time exceeds the allotment, however, it does this for all issues regardless of whether or not there was an original estimate.

Thanks in advance.

[Ignacio Aredez GenAI Expert · Accepted solution]

To set up an automation in Jira that sends an email when logged hours exceed the original estimate, but only if an original estimate exists, follow these condensed steps:

Trigger: Use "Work Logged" as the trigger.
Condition: Add an "Advanced compare condition" to check if the Original Estimate (originalEstimate) is not empty.

Condition: Add another "Advanced compare condition" to compare logged time (issue.timetracking.timeSpentSeconds) with the original estimate (issue.timetracking.originalEstimateSeconds). Ensure logged time is greater than the original estimate.

Action: Use "Send Email" to notify the relevant parties, configuring the email with details about the issue, such as issue key, summary, logged time, and original estimate.

Make sure to test this automation with a few issues to ensure it works as expected, and adjust permissions as needed to allow the rule to access work logs and issue details. This setup ensures email notifications are sent only for issues with an original estimate that has been exceeded by logged time.

[Carson]

Great thank you that worked perfectly.

I ended up using a "JQL Condition" saying "originalEstimate is NOT empty" and it validated correctly and sent an email correctly. For anyone else wanted the final product I've attached it below.