How to Automate Status Changes Based on Due Dates in monday.com
Managing due dates manually can be time-consuming and prone to errors. With monday.com automations, you can set up your boards to automatically update status columns when due dates approach, pass, or arrive—helping your team stay proactive and organized.
🎯 Why Automate Status Based on Due Dates?
- Save time by eliminating manual updates
- Prevent delays by flagging tasks before or after deadlines
- Improve accountability with consistent tracking
- Boost productivity by focusing on what needs attention today
🛠️ Step-by-Step: Set Up Date-Based Status Automations
Step 1: Open Your Board
Go to the board where you manage tasks with due dates and a status column.
Step 2: Click on “Automate”
At the top of your board, click the ⚙️ Automate button → then select “Create Custom Automation”.
Step 3: Choose the Automation Recipe
Use this common recipe:
“When date arrives, change status to something”
Or browse similar ones in the automation center under the “Dates” category.
📅 Example Automations
✅ 1. Mark Task as “Due Today”
When {Due Date} arrives, change {Status} to “Due Today”
⚠️ 2. Mark Task as “Overdue”
When {Due Date} has passed and {Status} is not “Done”, change status to “Overdue”
Tip: Use a status label like “Overdue” in red to easily spot late tasks.
🔜 3. Send Reminders Before the Deadline
When {Due Date} is 1 day before, notify {Assignee}
You can combine this with a status update:
When {Due Date} is 1 day before and {Status} is not “Done”, change status to “At Risk”
🔄 Combine with Other Automations
You can create a workflow where:
- The task turns “In Progress” when assigned
- Becomes “Due Today” on the deadline
- Becomes “Overdue” the day after if incomplete
- Automatically closes when status is set to “Done”
This ensures your tasks move automatically through their lifecycle.
🧠 Pro Tips
- Add a Time column with your Date column for more precise triggers
- Use automations in combination (e.g., update status + send notification)
- Create a dashboard widget to highlight overdue or upcoming tasks
- Set up a filter or view to show only overdue items for daily stand-ups
🚫 Common Pitfalls
Issue | Solution |
---|---|
Status not updating | Check if automation recipe uses correct column names |
Task already marked as Done | Use a condition: “If Status is not ‘Done’” |
Date is missing | Ensure all items have a value in the Date column |
Trigger runs late | Confirm your account timezone in settings |
✅ Summary
Feature | Available On |
---|---|
Date-based status updates | ✅ All paid plans |
Custom automation recipes | ✅ Standard & above |
Notifications based on dates | ✅ All plans |
Multi-step automation workflows | ✅ Pro & Enterprise |