How to Automate Status Changes Based on Due Dates in monday.com - Solution for Guru

Table of Contents
< All Topics
Print

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:

  1. The task turns “In Progress” when assigned
  2. Becomes “Due Today” on the deadline
  3. Becomes “Overdue” the day after if incomplete
  4. 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

IssueSolution
Status not updatingCheck if automation recipe uses correct column names
Task already marked as DoneUse a condition: “If Status is not ‘Done’”
Date is missingEnsure all items have a value in the Date column
Trigger runs lateConfirm your account timezone in settings

✅ Summary

FeatureAvailable 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