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
Community Members
Community Events
Community Groups

Automate Workflow Progression Based Off Due Dates

Hi y'all!

My company is working on a marketing CSV/workflow to be able to pull whenever we start a new marketing project. Since a lot of the issues/sub-tasks will be repeating monthly, we have multiple issues/sub-tasks repeated for each month, i.e. November Email Content, December Email Content, etc.


Is there a way to automate it that if it is imported with a due date, the task will automatically move to the "To-Do" column when it is i.e. 7 days out from the due date?


It looks like you can do it on Trello via Due Date Commands but I couldn't seem to find the same thing for Jira. Please let me know! Thank you!

1 answer

1 accepted

1 vote
Answer accepted
John Funk Community Leader Nov 17, 2020

Hi Julia - Welcome to the Atlassian Community!

You can certainly do that with an Automation For Jira rule. 

You would start with a Scheduled trigger to run each 1 day

Then base it on JQL - something like Project = ABC and duedate > startOfDay(7d)

Then add a New Action for Transition issue to move it to the To Do status. 

Hi John - Thank you so much! That solves it, I think. 

Thanks John!!

I took your answer and modified it to the following,


Project = ABC AND due <= 7d AND status != Done


Project = ABC AND due >= startOfDay(7d) AND due <= startOfDay(30d) AND status != Done

To run automation rules to check the tickets daily, then flow on from this component to an email and priority changing process.  

Like John Funk likes this

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events