Smart Value

Question

Within my automation rule, I have a field called activity date. The date is populated when it's assigned.

The next rule I need -

Trigger

Schedule

Condition - Advanced compare condition

First value - Calculate the business day when the ticket was assigned minus weekends or public holiday

Condition

Greater then

Second value - {{Issue,activity Date plus 7 days}}}

The purpose is that if the request hasn't moved to the next status after 7 days an email is then to the Line Manager. Remembering not to include Sat and Sun

Kateryna_v_SaaSJet_ · Answer

Hi @Nash

I didn't fully understand what “Advanced compare condition” you meant, but I found a possible solution. If you are okay with using third-party add-ons, here is an option that should work.

Using SLA Time and Report for Jira add-on, create a Work Schedule with the necessary working hours, breaks, weekends, and holidays.

Next, create an SLA configuration with this calendar. For a Start, set the Issue is Created condition, Any Assignee and the status of the issue when it will be created (for example, Backlog), and for Stop, set All other statuses.

Set the Trigger to 56 h (8 working hours per day*7 working days), and as an action – Notification in the comment to the task (at the same time, it will also be sent to the mail). You can create custom text for notifications if required.

Save it, and now the time count will be based exclusively on working days and times in the calendar.

Use the add-on trial to try this option, and I hope this solves your problem. My team developed the application, so if you need help setting it up, I will gladly help.

Walter Buggenhout · Answer

Hi @Nash,

If you are using an SLA, that is because you are probably using a 24/7 calendar with your SLA definition. You need to specify working hours and days in that SLA calendar and as soon as you're there, non working days will no longer be counted.

See this article to learn more.

Kes · Answer

It didn't work as it didn't calculate the business days