Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,360,197
Community Members
 
Community Events
168
Community Groups

Can you help me, how to set automation reminder(send email) when now date is 90 days before due date

I need a reminder automatically always starts when the now Date is 90 days before due date of my issue/task, then continually after that the reminder sent again every 1 weeks.

How can I set this condition?

Thank you

2 answers

2 accepted

1 vote
Answer accepted

Hi, @Agnes 

Actually, this may be easily done whin any amount of reminders you need. Recently, I've written a few articles about how you can set this process up: 

If you need, I (or my team) can show you how to set automation reminder whenever you need via SLA Time and Report for Jira add-on. This plugin can definitely help you with your question.

Let me know, if you need more information or help with such settings.

Have a great day.

Sincerely,
Olha

Dear @Olha Onofriichuk_SaaSJet ,

Well noted and thank you for your support..

@Agnes I'm glad it helped you! Feel free to message me if you need any help with setting up sending the reminders.

1 vote
Answer accepted
Mark Segall Community Leader Aug 31, 2022

Hi @Agnes and welcome to the community!

You had me intrigued with the need for weekly updates as I was thinking there has to be a straightforward way to handle this. Here's what I did in my test environment:

  • TRIGGER: Scheduled (Daily)
    • statusCategory != Done AND dueDate >= startOfDay() AND dueDate < startofDay(91d)
  • IF CONDITION (Advanced Compare): Here we check to see if this is the 90 day warning
    • {{now.plusDays(90).jiraDate}}
      Equals
      {{issue.dueDate}}
    • ACTION: Send Email
  • ELSE CONDITION (Advanced Compare):  Here's where we're checking to see if the issue is exactly n weeks from the Due Date.  This formula is evaluating whether it's a whole number.  If it is, send another alert.
    • {{#=}}FLOOR({{now.diff(issue.dueDate).days}}/7){{/}}
      Equals
      {{#=}}CEILING({{now.diff(issue.dueDate).days}}/7){{/}}
    • ACTION: Send Email

Here's a screenshot of what I did. I added variables in here for testing, but they could also be useful for giving dynamic email messages (e.g. You have n weeks remaining until your due date):

2022-08-31_13-11-27.jpg

Dear @Mark Segall ,

Thank you for your support. I have already tried it and success.

I can use it for my tasks..

Really appreciate for your response and help :)

Like Mark Segall likes this
Mark Segall Community Leader Sep 02, 2022

Fantastic!  

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Atlassian Automation

Jira Automation: Sum Up Story Points Roundup (Initiatives -> Epics -> Story/Tasks -> Subtasks)

Hi Everyone, In this roundup we combine all the jira automation rules to sum up story points across different issue types. We start from the lowest level, summing up story points from sub-tasks t...

3,103 views 10 9
Read article

Atlassian Community Events