Skip to main content

Due Date Field

Add a Due Date field linked to a Status field to track due, overdue and completed work with start and end dates.

Written by Emma Montgomery

The Due Date field tracks when work is due, how overdue it is and whether it was completed on time, and it must be linked to a Status field in the same table. It holds a start date and an end date, and it drives My Work, Calendar and Timeline views.

Plan Availability

All plan types.

Permissions

Administrators and Solution Managers: add, configure and delete fields in their solutions.

Platform

Web

Related Reading


What does the Due Date field do?

  • Counts the days until due, the days overdue and the completion date.

  • Works like a Date Range field, with a start date and an end date.

  • Shows as one value, or as separate Start Date and End Date columns.

A Grid View with a Due Date field showing a due date and its status indicator

How do I add a Due Date field?

Add it from Grid View or from a record; either way it must be linked to a Status field.

From Grid View

  1. Open the table in Grid View.

  2. Select the + at the right end of the column headers, or open a column's menu and select Add Field to the Right.

  3. Select Due Date, name the field and set its options.

  4. Check the Linked Status Field (the first Status field in the table is selected), then select Add Field.

The field type list in Grid View with Due Date selected

From Record View

  1. Open a record.

  2. Hover an existing field and select + (Insert new field below), or select + Add new field to this Table at the bottom of the record.

  3. Select Due Date, name the field and set its options.

  4. Check the Linked Status Field, then select Add Field.

A record open with the Add Field menu and Due Date selected

Important: Every Due Date field needs a Status field. If the table has none, SmartSuite shows a message asking you to create one first.

The message shown when a table has no Status field to link the Due Date to

Which settings can I change?

  1. Name: Due Date by default; change it at the top of the settings window. Names are unique in a table.

  2. Display Format: Compact (01/16/2025), Standard (Jan 16, 2025) or Long (Thu, Jan 16, 2025, 9:00 AM). Time is optional and formats follow the locale.

  3. Linked Status Field: the Status field that tracks progress toward this due date; the first Status field in the table is selected. The status marked as complete in that field completes the due date.

  4. Require an entry in this field: a record with an empty due date cannot be saved ("Due Date is required").

  5. Default Date (Defaults tab): No Default Date, Today, Today Plus a number of days (1 to 999) or a Specific Date. It fills new records only. See Default Text/Values in Fields.

  6. Help Text: a note shown as a tooltip or below the field name. See Adding/Modifying Field Help Text.

The Display Format setting of a Due Date field with the three formats

The Linked Status Field setting of a Due Date field

How do start and end dates work?

  • Each Due Date field holds a start date and an end date, so a plan needs no extra date fields.

  • Optional: add a time to each date.

  • For a single due date, leave the start date empty; inline edits fill the end date.

  • Optional: select the repeat icon at the bottom of the date picker to make the task repeat. See Repeating Tasks.

  • If the start date is after the end date, SmartSuite swaps them.

A Due Date field open in a record showing the start date and end date pickers

What do the status indicators mean?

State

Indicator

More than 60 days before the due date.

An orange smiley face.

Due in 0 to 60 days.

An orange counter with the days left (0 = due today).

Overdue by 1 to 60 days.

A red counter with the days overdue.

Overdue by more than 60 days.

A red sad face.

Completed on time.

A green check mark.

Completed late.

A green check mark with a red dot.

A Status field can mark more than one value as complete, for example Won and Lost, which also helps automations and calculated fields.

The Status field settings with two values marked as complete

How do I show start and end dates in a view?

  1. Open Fields to Display and select the + beside the Due Date field (it is available when the Due Date field itself is not shown).

  2. Select Start Date and End Date to show them as separate columns, or keep the combined value.

The field display menu with Start Date and End Date listed under the Due Date field

How does Due Date work with My Work?

When the Due Date field is linked to a Status field that is also linked to an Assigned To field, the record appears as a task in My Work, grouped by due date. Changing the due date in My Work updates the record.

The My Work panel listing tasks grouped by their due date

How do I use due dates in views?

  • Filters and Spotlights: use conditions such as Is overdue and Is not overdue, and highlight overdue records.

  • Filter conditions: is, is not, is before, is after, is on or before, is on or after, is empty, is not empty, is overdue and is not overdue. Is overdue also shows tasks completed after the due date.

  • Group: group records by a Due Date field to see them as Complete, In process and Overdue.

  • Calendar and Timeline views: drag and resize tasks to change their dates.

  • Checklist field: checklist items carry their own due dates.

A filter on a Due Date field with the Is overdue condition

A Timeline view with a task bar being resized to change its due date

Where else can I use a Due Date field?

Due Date fields can be used in Formula fields (for example MONTH([Due Date]) uses the end date) and in Lookup fields (also only the Start Date or End Date). They also work in the filters of Lookup, Count and Rollup fields, and in Auto-Generated Titles.

Change type: a Due Date field can be changed to Text, Text Area, SmartDoc or Date. See Changing a Field's Type.

Last verified 29 Oct 2026.

Did this answer your question?