Update a "Due Status" column based on another Status column
Apps used in template
About
Use this template to update a "Due Status" column based on another Status column and the Item's Due Date. This will show you if a Item is Upcoming, Due Today, or Overdue.
Trusted by thousands of fast-scaling organizations around the globe
Similar templates for inspiration
Looking to get more out of your apps? With Make, you can visually integrate any app into any workflow to save time and resources - no coding required. Try any of these templates in just a few clicks.
Save time by automatically generating completions to any topic, for example, SEO keywords from your content topics. Learn more
Every time you add a new row to your Google Sheets spreadsheet, Make will automatically create a new task in ClickUp. The template uses this example spreadsheet.
Every time a new task is created in ClickUp, Make will automatically add that task's info to a new row in your Google Sheets. The template uses this example spreadsheet.
Every time a new row is added to a Google Sheets spreadsheet, Make will automatically create a new card in Trello. The template uses this example spreadsheet.
Every time you add a new row to your Google Sheets spreadsheet, Make will automatically send a message in Twilio. The template uses this example spreadsheet.
This Template helps you export a collection of Firestore documents to Google Sheets. Make will automatically save all document field values in a new spreadsheet row. This scenario uses this example spreadsheet. Prerequisite: This template can't save fields of Array, Map or Geo type.
Create your own workflow
Create custom workflows by choosing triggers, actions, and searches. A trigger is an event that launches the workflow, an action is the event.
Adds subscribers to a board by their IDs and the board ID.
Adds a new column to a specific board.
Adds a file to a file column value.
Adds a file to an existing update.
Creates a new board.
Creates a new group in a specific board.
Creates subitem of an item.
Creates an item.
FAQ
How Make works
Thousands of fast-scaling businesses create and automate on Make
Trusted by 500,000+ Makers
"Make really helped us to scale our operations, take the friction out of our processes, reduce costs, and relieved our support team. It is difficult to not become a fan."
"Make drives unprecedented efficiency within our business in ways we never imagined. It’s having an extra employee (or 10) for a fraction of the cost."
"The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."
"True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."