Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Community showcase
Published in Apps & Integrations

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...

727 views 7 24
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you