How do date triggers work in rules? (Title changed)

[ka_nishiyama]

If I set the trigger for a rule to “Task is overdue” will the rule not work on completed tasks?

For example, I set up a process to delete a task from the project a specified number of days (e.g., 3 days) after completion, but it doesn’t seem to be executed.

If rules can’t be applied to completed tasks, are there any alternatives?

---

Currently, it doesn’t seem to be triggered on completed tasks.
I think it’s necessary for Multi-home feature of asana.

Allow "Task is Overdue" trigger to work for completed tasks

Currently, in Rules within the Triggers menu under the “Task Timing” section there are only three types of triggers: Task is no longer blocked, Due Date is approaching, and Task is overdue. The request is to add a fourth trigger type for “Task is completed.” The requested “Task is Completed” trigger would allow you to trigger a rule after X period of time from the date/timestamp of a task being completed. The existing trigger for “Tasks is overdue” only functions for incomplete tasks, so it can…

[Richard_Sather]

@ka_nishiyama

I set up a process to delete a task from the project a specified number of days

Hi @ka_nishiyama , there isn’t a rule action to delete a task. Perhaps you mean to remove the task from a project?

And, no, the ‘when overdue’ trigger will not run on completed tasks because the task is no longer regarded as overdue since it is completed. However, I can understand your use case, although I’ve never come across this need with any of the numerous customers we’ve worked with.

[Richard_Sather]

Actually, @ka_nishiyama, you could try creating a formula field A that is (Completed date +3 days, for example) and then another formula field B that is (Formula A - Today).

Then you could create a rule trigger when Formula B is changed and Number is equal to 0, then run your action.

I haven’t tried this but it should work in theory, although I’ve ran into some bugs when triggering formula number fields..

Rules not triggering when 'Number is' condition is a formula field

@Forum-team , I kindly ask that you escalate this issue to the product team to have a look - this one is definitely in the ‘not expected behaviour’ category Not sure whether the introduction of (the very useful) formatting feature within formulas has caused this to break, or it was always the case but I will try and explain as best as possible in order for you to recreate, test, and hopefully fix since the use cases are numerous! One use case is to set a single-selec…

[ka_nishiyama]

Hi @Richard_Sather

I’m considering the following behavior.

Base Project

• Project A: Tasks A1-A50
• Project B: Tasks B1-B50

Project C: Displaying tasks within a specified period

• Displaying tasks from 3 days before to 3 days after today’s date
• Tasks can be completed or incomplete.

Task manipulation based on rules

• Multi-home from Projects A and B to C based on the due date
• Delete overdue tasks from C.

[ka_nishiyama]

@Richard_Sather

Completed date +3 days, fo

Cannot execute “creating a formula field A that is (Completed date +3 days)”.

[Richard_Sather]

You need to use the DateAdd function

[ka_nishiyama]

An error occurs and you cannot proceed.

The output of a formula cannot change from a date to number, or vice versa. Please create a new formula.

[Richard_Sather]

Yes, this is expected, you cannot modify an existing one. Did you try creating a new formula from scratch?

[ka_nishiyama]

@川村風太 , thank you for the information.

I tested rule execution using due dates and date (field types).

This is the current rule execution status (Asana’s features are constantly changing, so this is the current status). Therefore, I changed the title.

1 For due dates

• Timing: When changed, Rule execution: Execute tasks = OK, Completed tasks = OK
• Timing: When approaching, Rule execution: Execute tasks = OK, Completed tasks = NG
• Timing: When overdue, Rule execution: Execute tasks = OK, Completed tasks = NG

2 For date fields

• Timing: When changed, Rule execution: Execute tasks = OK, Completed tasks = OK
• Timing: When approaching, Rule execution: Execute tasks = OK, Completed tasks = OK
• Timing: When overdue, Rule execution: Execute tasks = OK, Completed tasks = OK