Send mail based on end date of sprint

[Marco K_]

Hi all,

I'm trying to make this automation rule work;

1. Every day check if 

2. {{now.shortDate}} less then {{sprint.endDate.minusDays(workday(now,sprint.endDate,7))}}

3. then: send e-mail

Unfortunately it's not working, what am I doing wrong here? 

[Trudy Claspill]

Hello @Marco K_ 

Thank you for providing the screen image of your rule.

Can you also provide:

1. The details of the Schedule trigger? Specifically it would be helpful to know if you are running a JQL in that trigger and what that JQL is.

2. The log from the rule's execution. Get that from the page that you access through the Audit Log button. That will show you multiple log entries for each time the rule was changed and saved, and each time it ran. You can expand each entry to see more details. We need the details from when the rule ran.

I suspect the problem is that the rule has no understanding of which sprint you want to consider in your rule.

Can you explain that to us? Are you trying to look at one specific, named sprint? Are you trying to look at all sprints across your instance or in a specific Scrum board?

Can you explain what criteria you want to apply to the sprint end date to decide if the email should be sent? I'm not able to discern that from the image you provided.

What are you trying to accomplish with the smart value that you have specified as the second value in the condition? I don't think that is valid, but I can't suggest how to correct it until I understand what you are trying to do.

Can you explain to us the problem you are trying to solve? We might be able to suggest an alternate solution that will work.