How to move a task from ToDo to Doing based on Due Date?

[Harry Klein]

I want to automatically move Tasks in ToDo to Doing if the Task Due date is 2 weeks from today.

I created this automation, but it's not working. Any thoughts why?

(I'm thinking I need to name my ToDo column Backlog and then move Tasks with Due dates 2 weeks from today to ToDo so I don't clutter my Doing list.)

Thanks in advance for any and all assistance.

Harry

[Piyush A (STR) · Accepted solution]

Hi,

You can create a Scheduled trigger with Automation For Jira. Have it run daily (every one days).

Then use the JQL Condition for the due date query.

Then New Action for Transition issue to required status

[Harry Klein]

Thanks @Piyush A (STR)

I'll try that. This is my first time writing a JQL Condition in Jira (or anywhere honestly). 

Will Basic work or do I need to run Advanced?

Thanks,

Harry

[Piyush A (STR)]

Hi,

 advanced here - 

Status in (To Do) and duedate >= now() AND duedate <= endOfDay("+14")

[Ravi Sagar _Sparxsys_ · Accepted solution]

Hi @Harry Klein 

Your rule's trigger is issue created so it will only run once.

What you need is scheduled trigger.

Ravi

[Harry Klein]

Thanks @Ravi Sagar _Sparxsys_ I'm looking into that now.