Definition

In Notion, the Number property enables you to store and manage numeric data within database entries. You can choose from various formats such as plain number, percent, currency (USD, EUR), and duration, ensuring values display consistently across your workspace. Under the hood, Number fields accept integers, decimals, and negative values, and integrate seamlessly with formulas and rollups to power calculations, summaries, and analytics.

Usage & Context

When building a database to track budgets, inventory, task estimates, or scores, add a Number property to record quantities, costs, percentages, or ratings. Enter values directly in the column of a Table view or via the property panel in any other view type. Adjust number formats by clicking the property name in the database header, selecting "Edit property," and choosing options like "Percent," "Dollar (USD)," or "Duration." This choice applies across all views and improves filtering, sorting, and aggregation.

Frequently Asked Questions

How do I change the format of a Number property?: Click the property header, select "Edit property," open the "Format" dropdown, and pick from options like Number, Percent, Currency, or Duration.
Can I use Number properties in formulas?: Yes. Formulas can reference Number fields to perform arithmetic operations, averages, and more complex calculations.
What precision do Number properties support?: You can set decimal precision from 0 to 5 decimal places in the property settings, allowing exact control over rounding.
How do I filter entries based on a Number property?: In any database view, click "Filter," choose your Number property, and select a condition (e.g., "is greater than", "is less than") to narrow entries.
Can I perform aggregations on Number columns?: Yes. In Table and Board views, click "Calculate" at the bottom of a Number column to display sums, averages, medians, and other aggregation options.

Benefits

Using the Number property ensures that all numeric data is accurately recorded and consistently formatted, enabling clear reporting, reliable filtering, and seamless integration with formulas and rollups.

Related Terms

Aggregation

Database Views & Filtering+2

Feature that calculates summary values—sums, averages, counts, and more—across database entries, giving quick insights at the bottom of any view.

Formula

Database Properties+2

A database property that calculates and transforms values using functions. Create dynamic outputs like dates, text manipulation, logical checks, and math operations.

Filter

Database Views & Filtering+2

Filters in Notion let users narrow down database items by setting conditions. Use single or multiple criteria to customize views and focus on relevant data.

Database Sort

Database Views & Filtering+2

Database Sort lets you order entries in a Notion database by one or more properties in ascending or descending order to highlight key information.

Database

Core Concepts+2

A Database in Notion is a collection of structured pages with customizable properties and flexible views. Organize and track tasks, notes, projects, or any data dynamically.

Conclusion

The Number property is a core Notion feature that empowers users to capture and process quantitative information reliably. Its flexible formatting, precision control, and compatibility with advanced logic make it indispensable for budgeting, analytics, and project management.

Ready to capture numeric data with NoteForms?

Try NoteForms for free

Loved by our customers

100.000+ users and companies have chosen NoteForms
to build beautiful & powerful forms with Notion

Create a form for free