I have a board setup with date started, due date dependent on offset and I want to 1. set date started to either previous rows due date or all start dates to same as project start date. Then I want to update status to in progress on next row once due date arrives as this will then notify owner of need to start task. Any help with automating process gladly welcomed? Thanks
Hi Simon!
I”m a little unclear on a few points, but let me share what I can:
If your project start dates are all the same, you could easily set up an automation “When item created, set start date as today”.
You could also have the start date change to the date someone changes its status to “working on it” for example. Simple automation: “When status changes to Working On It (or in progress, or whatever you like), set date to today.
If you’ve got all regular items and not referring to subitems, if you have dependencies from the lower item to the one above it, you could use an automation that says “When date arrives and only if status is ‘working on it’, set date to whatever that is.
Alternatively, you could use a drop down column to assign the number of days to offset this, and when something’s status changes to working on it, set start date to today. If that were the case I would actually build one automation for each # of days to offset the due date:
When status changes to working on it, and only if dropdown column is 5 (for example), then set start date as today, then set due date as today and then push due date by 5 business days.
If this doesn’t line up with what you’re asking, please feel free to share some screenshots or a loom.
Hello @simon.jones
Yep, you can automate most of this
For Start Dates, the simplest is setting all items to match one Project Start Date, then using Dependencies + date offsets to calculate Due Dates.
For “when Due Date arrives, move next row to In Progress,” monday.com native automations don’t reliably trigger cross item updates between rows. Most people solve that with a daily check automation or an integration tool (Make/Zapier) for true “next item” logic.
If you’d like hands-on help or want us to walk through this live, you can book a 1:1 paid 60-minute strategy session with our team here:
Calendly
hi @simon.jones ! Once the status flips automatically on the due date, Time in Status lets you see exactly when each task entered In Progress, how long it stayed there, and whether things are starting late even if the dates are set correctly. That’s really helpful for validating that this kind of chained, date-driven workflow is actually working in practice.
There’s a 14-day trial, and happy to walk through the setup on a quick demo if helpful.