Automate a task to start based on workdays or calendar days based on conditions met

On my board I want to be able to automate an activity to create a new task and set a start date, for a given number of days, in the future for the task. Crucially, in this automation, I want to be able to specify whether the start date is based on calendar days or work days.

For context I have a task that I want to start 60+ work days from the point the last task was completed.

Example 1 (Workdays):

Where status column titled “Overall Status” is complete
and status column titled “Regular Deliverable” is “yes”
and status column titled “Recurrence” is “Workdays”

Then create a new task in the same board and same group with the start date “##” number of working days from the date at which the status was changed to complete.
Or alternatively, from “today”

Example 2 (Calendar Days):

Where status column titled “Overall Status” is complete
and status column titled “Regular Deliverable” is “yes”
and status column titled “Recurrence” is “Calendar days”

Then create a new task in the same board and same group with the start date “##” number of calendar days from the date at which the status was changed to complete.
Or alternatively, from “today”

1 Like

Can you add in the option to account for UK and US Bank Holidays too?

Hi @esankey

We have solved this by implementing WorkDays Calculator in Make - integrating with Monday Board.

Features:

  1. Add/Subtract Days
  2. Input number of days
  3. Input customized holiday list

If you are new to Make, signup using below link:
https://www.make.com/en/register?pc=msquare

To implement the workdays calculator in 30 mins, reach out to us @ Calendly - Msquare

MSquare Support
Visit us here
Youtube Channel