Column Data Type

Text

Free-form strings for names, titles, IDs, and descriptions. Text sorts alphabetically and works with search and filters as you type.

Use case: Document library

Acme Co — Knowledge Base

Titles and authors as Text ensure proper A–Z order.

Set both “Title” and “Author” to Text so lists stay consistently alphabetized.

Number

Numeric values for prices, quantities, scores, or percentages. Choose a display format; formatting doesn’t change the underlying value.

Formats

• Default — Plain integer (e.g., 1234567890).
• Decimal — Thousands separators with configurable decimals (e.g., 1,234,567.89).
• Compact — Abbreviated for dashboards (e.g., 1.23B, 3.4K).
• Currency — Locale-aware with symbol (e.g., $1,234,567.89); choose currency (USD, EUR, GBP, JPY, CAD, AUD, CHF, CNY, …) and decimal places.

Use case: Budget tracker

Acme Co — Finance

Multi-currency reporting made readable at a glance.

Set the “Amount” column to Number → Currency (e.g., EUR) with two decimals. Values display with symbols and sort correctly for monthly rollups.

Date

Calendar dates and timestamps for events, deadlines, and created/updated fields. Sorting is chronological; filtering supports ranges.

Formats

• Default (based on locale) — Uses the viewer’s locale (e.g., 10/15/2025 or 15/10/2025).
• ISO8601 — Standard YYYY-MM-DD (e.g., 2025-01-15).
• Custom format — Supply a pattern to match your conventions.

If a value can’t be parsed, the preview shows Invalid date until corrected.

Use case: Release schedule

Acme Co — Product

Dates that actually sort like dates.

Set “Release Date” to Date with ISO8601 for consistent sorting across locales.

Boolean

True/false flags for status fields such as Active, Completed, or Approved. Filter by True/False and sort with checked values together.

Use case: Task completion

Hikari Solutions — PMO

A simple checkbox tells you what’s done.

Convert “Done?” to Boolean so teams can filter to completed tasks during stand-ups.

Enum

A fixed set of labels (e.g., Status, Priority, Category) for consistent filtering and grouping.

Appearance

• Pills — Colored lozenge/pill format (default).
• Simple — Small colored circle with text.
• Colored text — Text colored by value.
• Raw — Plain text with tooltip.

Manage values

• Discovered values show unique labels found in the column.
• Use Add new value to introduce a label that isn’t present yet.
• Remove labels to limit the allowed set (cells keep their text until edited).

Use case: Article status

Knowledge Base — Documentation Team

Clean filters and totals by label.

Convert “Status” to Enum with values Draft, In review, Approved, Archived. Choose Pills for quick scanning, or Colored text when you want emphasis without badges.