Rule condition for "Due date is {+/- x} days away"

My use case:
I want a rule that will flag form submissions if the due date is within the next two weeks (i.e., less than or equal to 14 days after today). I would like to trigger on “Task is added to this project” and condition on this due date operation.

There are numerous other feedback requests about similar asks (more flexibility in the due date approaching trigger, for example), but I don’t think any of them address my need. In the meantime, does anyone have any workarounds for this that do not utilize 3rd party tools (I also need it to trigger relatively immediately, so the due date approaching trigger won’t work for me)?

I have a user who is wondering if there’s a way to have rules run on tasks when they are assigned that would sort them into the appropriate section based on due date.

She’d like to be able to avoid manually triaging the Recently Assigned section — so would I, tbh — by having a rules that do:
When: Task is added to My Tasks
Check if: Due date is within [ 3 days / 1 week / more than 1 week ]
Do this: Move task to section: [ Do Today / Do This Week / Do Later ]

But on the Check If, the only options for checking due date are all based on fixed calendar dates (which honestly seems like it would almost never by useful).

Has anyone found a way to work around this? And is there a product feedback submission I can vote on to have dynamic date options in the Check If section of the rule builder?

I’ve merged your post into an existing thread where you can click the title to scroll to the top and vote by clicking the purple Vote button.

I believe Flowsana.net currently offers this (@Phil_Seeman).

Thanks,

Larry

Yes, Flowsana provides this exact functionality in our new rule builder, coming out next Monday! We’ll post more at that time, but feel free to contact us before then for more info if desired.

2 Likes