Check for Tasks that are due today irrespective of its completion status

[MADHUSUDAN_BELLUR_SH]

I want to set a rule in which a specific field (Planned Completion) needs to update with a value 1 when the task becomes due today.

I have set this rule with Due date approaching function. However, this rule does not work in a scenario, when a task is completed ahead of the schedule. (ex: when a task is marked completed on the 02-Mar while the due date is on the 04-Mar). Any advise.

[ka_nishiyama]

Hi @MADHUSUDAN_BELLUR_SH
Please confirm your desired status.

Condition

• The specific field (Planned Completion) is a numeric value.

Action

• If the task is completed, Planned Completion = 1.
• If the task is incomplete, Planned Completion = 0.

Proposed rule for consideration (What do you think of the following rules?)

[Joanna_Colgan]

Hello @MADHUSUDAN_BELLUR_SH , and welcome to the Forum!

Let us know if the solution @ka_nishiyama will work for your case scenario? Depending what is the reasoning/need behind this rule, different solutions might work.

You can even combine different triggers into one rule, so the rule would run when either trigger is met: