Automation - Sending an E-Mail 3 days before the task is due

[Admin OKZT]

Hello,

we created a rule that an e-mail is sent as a reminder three days before the task is due. This one works just fine. But now I need an adjustment.

This is the rules as it is right now:

But now I need it to exclude this whole column:

I can't mark the column as "done" but I also don't need the E-Mail notification for this one. 

Does anyone know how to fix this? 

Best regards

Jenny

[Ścisiński Jakub · Accepted solution]

Another AND in first jql containing status not in ('ANGEBOT ABGEGEBEN'). This will exclude all issues from this status for mail notifications.

[Admin OKZT]

Like this? 

Frist <= endOfDay({{numberOfDaysBeforeDueInclusion}}) AND statusCategory != done AND status !=('ANGEBOT ABGEGEBEN') AND assignee != empty

[Ścisiński Jakub]

Should be like that, if it is not working (not showing proper output)  then you can add how exactly that column is defined. What is contained there. 

Because even if one status is in two columns it has to be defined somehow.

[Admin OKZT]

Thank you, I will try it. The Workflow looks like this - maybe that helps? 

[Ścisiński Jakub]

Excellent! So this JQL

 Frist <= endOfDay({{numberOfDaysBeforeDueInclusion}}) AND statusCategory != done AND status !=('ANGEBOT ABGEGEBEN') AND assignee != empty

should work just fine. It will filter out not needed issues and will not notify anyone with mail.

[Admin OKZT]

Thanks a lot for your help. 

[Fazila Ashraf]

Hi @Admin OKZT 

What are the statuses mapped to that column?

In the JQL attached to the 'scheduled' trigger in the automation, you can specify to exclude those statues.

[Admin OKZT]

Status = In Progress.

The problem with this one is, that I have 2 columns with the same status and I only need to exclude one.

[Fazila Ashraf]

@Admin OKZT , In a board, a status can be mapped to only one column. Can you explain how you mapped the inprogress status to 2 columns?