Hi I need some help with automatically moving items into groups based on due dates.
I have 4 groups for all my job items - “due today” , “due this week”, “due next week”, and " confirmed jobs"
I want the jobs to be moved to the right group automatically.
Currently I can get the jobs into “due today” with no problem, but for “due this week” and “due next week” I am unable to get the automation going smoothly.
If I set items to move 7 days prior due date, items due next work week might show up in “due this week” depending on which day of the week it is at the moment (e. if today is Thursday, items due next mon-wed will be moved to due this week if I set it to be moved 7 days prior due date). Same issue happen for setting up “due next week”.
I need the moving to happen on a specific week day prior due date rather than X days prior the due date.
Automations I am thinking of are:
- on 1st Sunday before due date at 7pm , move item to “due this week”
- on 2nd Sunday before due date at 7pm , move item to “due next week”
Is there any way to achieve this?