Others

How to Create a Priority Column Based on Due Date in Microsoft Lists

Maira Mehtab Sep 27, 2026 870 views

Question details

The user wants to automatically calculate and assign a priority level to list items based on an upcoming due date.

Product: Microsoft Lists
Device & OS: not provided
Scenario: Managing tasks or deadlines where the priority status needs to be dynamically updated as the due date approaches.
Observed behavior: The user attempted to use a Choice column to calculate the priority, but a Choice column is static and cannot reference or calculate values from a due-date field.

Before you start

Ensure you have Edit permissions for the Microsoft List so you can add new columns and access the list settings.

Solution 1Recommended

Use a Calculated Column to Determine Priority

Replace the static Choice column with a Calculated column to evaluate the due date using formulas.

A standard Choice column in Microsoft Lists relies on manual selection and cannot compute data dynamically. To automate priority assignments based on another field like a Due Date, you must use a Calculated column. This allows you to apply Excel-style logical formulas.

Add a new column

Open your Microsoft List, scroll to the rightmost column header, and click on 'Add column'.

Select the Calculated type

Click 'See all column types' or navigate to 'More'. Choose 'Calculated (calculation based on other columns)' and click Next.

Input the calculation formula

Name the column 'Priority'. In the Formula box, type an IF statement referencing your date column, for example: =IF([Due Date]<TODAY()+3, "High", "Normal").

Set the output data type

Under 'The data type returned from this formula is', select 'Single line of text', then click 'OK' to save your changes.

Formula Testing Tip: Test your logic by temporarily changing the due dates on a few sample list items to verify that the Priority column updates to the expected values.

Free Microsoft Office alternative

Manage Task Lists and Due Dates Easily with WPS Spreadsheet

If you are looking for a highly customizable and flexible way to track tasks, due dates, and priorities without dealing with complex list settings, WPS Spreadsheet is an excellent, free alternative. It provides powerful, familiar calculation features.

1. Create a Task Tracker: Open WPS Office and create a new Spreadsheet with headers for Task, Due Date, and Priority.
2. Insert the IF Formula: In the Priority column, enter a standard IF formula referencing the Due Date cell to output the priority status.
3. Highlight Important Tasks: Use Conditional Formatting under the Home tab to automatically turn High Priority rows red.

Fully compatible with Microsoft Excel (.xlsx) formats for easy data migration.Use familiar IF formulas to automatically calculate priorities based on task deadlines.Apply rich conditional formatting to instantly highlight overdue or high-priority items.Free, lightweight, and works seamlessly across Windows, Mac, iOS, and Android.

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I use a Choice column to calculate priority?

A Choice column is designed strictly for manual, predefined data entry. It does not possess the backend ability to read data from other columns or process logical formulas. A Calculated column must be used for dynamic data.

How can I provide sample data to test my list formulas?

To test without affecting live data, you can export your current list to a spreadsheet program, replace real names and information with dummy sample values, and import it as a new test list in Microsoft Lists to safely refine your formulas.

What if the Calculated column option is missing?

The Calculated column type might be hidden depending on the modern list view or permissions. Try clicking the gear icon, navigating to 'List settings', and adding the column from the classic settings menu. Ensure you have the required Owner or Editor permissions.

Office Quick Solutions