Skip to content
Tutorials Center
My learning

Topics

Lesson 11 of 36 ยท Databases

Property Types

A complete guide to Notion database property types: text, number, select, multi-select, status, date, person, checkbox, URL, created time and more.

Choosing the right property type is the most important decision in a database. The type decides how a value is entered, how it can be filtered and sorted, and what you can calculate from it later. This lesson walks through the property types available in current Notion versions.

The list of types occasionally grows. If a name below does not appear in your menu, check the Property type list when you add a column.

The core types

Type Holds Typical use
Title Text (required) The name of the page
Text Plain text Notes, short descriptions
Number A number with optional format Price, quantity, hours; formats include percent and currency
Select One option from a list Priority, category
Multi-select Several options Tags, skills
Status One option grouped into To-do, In progress, Complete Workflow stage
Date A date, time or range Due date, event date
Person One or more workspace members Owner, assignee
Files & media Uploads or links Attachments
Checkbox True or false Done, paid
URL, Email, Phone Validated links Contacts, resources

Pick the type by the question

One of a few choices Select or Status.
Several labels Multi-select.
A when Date, with optional end date.
A who Person.
1 / 2

Select, Multi-select and Status

Select stores exactly one option. Options are created on the fly by typing in the cell, and each gets a color. Multi-select stores any number of options. Choose Select when the answer is single (a priority) and Multi-select when several apply (tags).

Status is a special select with three built-in groups: Not started, In progress and Done. You can have several options in each group (for example, Backlog and Planned in Not started). Grouping lets Notion treat all "done" options alike when counting progress. Use Status for anything that moves through stages; use plain Select for categories.

Date

A Date property can hold a single date, a start and end (End date toggle) and optionally a time and time zone. Date properties power calendars and timelines. Reminders can be set per cell. Choose a date format (full, relative such as "Today", or ISO) in the property's settings.

Person and files

Person lets you assign members; assigning someone can notify them. Files & media stores attachments per row. Both are meant for collaborative databases, so they matter most once you reach the collaboration chapter later in the course.

Automatic properties

  • Created time and Created by: set once, cannot be edited.
  • Last edited time and Last edited by: update whenever the page changes.
  • ID (Unique ID): a sequential number with an optional prefix such as TASK-12. Useful for referencing tickets.

Later chapters add Formula, Relation, Rollup and Button properties, which are covered separately because they compute or connect.

Validating values

Types constrain what a cell accepts. This stand-in validates values against type rules, the way Notion's editor would refuse a letter in a Number cell.

JS Validate cell values by type (stand-in)

Press Run (or Ctrl + Enter) to see the console output here.

No output.

JS Status groups and progress (stand-in)

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Choosing well: a checklist

  1. If you will sum or average it, it must be Number, not Text.
  2. If you will sort by time, it must be Date.
  3. If the options might multiply uncontrollably (clients, projects), use a Relation to another database instead of a Select (see Relations Between Databases).
  4. Prefer Status to Select for workflow stages.
  5. You can change a property's type later, but converting from Text to Select can lose data that does not match, so keep backups.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. Which type is best for a workflow stage such as Not started, In progress, Done?

    Status groups options into stages, which also helps Notion calculate progress.
  2. 2. When should you choose Multi-select instead of Select?

    Multi-select stores any number of options; Select stores exactly one.
  3. 3. Why store a price as a Number and not Text?

    Only Number values can be calculated and sorted numerically.
  4. 4. Which property records when a page was created and cannot be edited?

    Created time is set automatically and is read-only.

Summary

  • Pick the type by what you want to do with the value later.
  • Select is one option; Multi-select is many; Status adds stage groups.
  • Date powers calendars; Person assigns owners.
  • Automatic properties track creation and edits.

Next: Views: Table, Board, Calendar and More