How to create formula in Notion on Mac: step by step for the desktop app

What you need before you start

The steps below follow the path in Notion's own formula help. You need the Notion desktop app for Mac and a database to hold the formula. Formula properties are columns, so a plain page with no database will not take one.

If you have not installed the app yet, follow how to install the Notion desktop app on Mac first. The help pages describe the same formula steps for every platform, so the menu path should look the same in the web app.

Create a formula property step by step

Start by opening the database itself. Then open its settings from the slider icon near the top of the page. That icon leads to the Edit properties list, where new columns are created.

After you pick Formula, Notion asks for a name. The name is optional. Choose something short, though, because you will type it inside other formulas. Property names go inside prop() in quotes, so a clear name saves typing errors later.

Where the slider icon is and what it is called

Notion's help pages call the control View settings on one page and View options on another. Look for the slider symbol near the top, and trust the label you see on your own screen. The table below lists the four routes to a new formula column.

Other ways to add a formula column

The settings panel is the most reliable route. It works on every database, and it is the path the formula help page describes. Use the other routes when a column is already on screen and you want the new one next to it.

The plus sign sits beside the rightmost column header. Click it, choose Formula, and the new column lands at the far right. To place it next to a specific column, click that column's header and choose Insert left or Insert right.

An empty database has no column headers to click, so use Add property instead. Enter a name, pick a type, and choose Formula. The first property is the only one that uses this route.

Write the formula in the Notion formula editor

When you click Edit formula, the formula editor opens. The left panel lists your properties, built-in values and functions. Use it to find the names you need before you type.

The right panel describes an element when you hover over it. Hover before you use an unfamiliar function, so you know what it expects. That check takes seconds, and it catches many wrong-type mistakes early.

If you opened the editor from a database row, a live preview shows the result for that row. Test against a record you already know. A known value makes a wrong result easy to spot.

A worked example: price times quantity

Say your database tracks orders. It has a number property called Price and another called Quantity. A formula property called Total can multiply them with prop('Price') * prop('Quantity').

Now suppose one row has no Quantity yet. That row can return an empty or wrong total. Notion's common errors page shows if() and ifs() for undefined values, though its examples focus on dates and people. The same idea can return a blank or a fallback for a missing number.

Test with one row first. Then copy the working pattern into other formulas. Keep each property focused on one job, because a formula that does three things is harder to debug than three small ones.

Mac checks: updates, refresh, and your chip

The Mac app updates itself, but you can check by hand. Click Notion in the menu bar and choose Check for Updates. Then press ⌘R to refresh the app and load new features.

• Check for updates: Notion > Check for Updates
• Refresh the app: ⌘R
• Installed version: the ? menu in the sidebar, then More
• Chip type: Apple menu > About This Mac

Your chip matters only when the app will not open. An incompatible download gives you a message that the application is not supported on this Mac. Compare your chip with the build you installed, then follow the fix guide.

Notion's releases page lists Notion 3.8 from October 13, 2026, and 3.7 from September 15, 2026. The page does not say those are Mac app versions. Use the ? menu to read the build number on your own machine.

Limits you will hit: property count and formula depth

Each database can hold up to 500 properties. When you reach that number, Notion does not create the new property and shows an error. Delete properties you no longer use, or combine similar ones, and try again.

Formulas also have a depth limit. Notion's common errors page says a formula can nest 15 layers. Each reference to another formula or rollup adds one layer, even across databases.

That depth rule sits in a section written mostly for automations, so it may not apply to formula properties the same way. If you hit it, merge similar formulas and rollups into fewer properties. Fewer properties mean fewer links in the chain.

Mistakes people make with Notion formulas

• Mistyping a property name. Match the column header exactly, because you type it inside prop().
• Choosing the wrong return type. The result has to fit the property you are building.
• Ignoring empty values. A blank date or person can break a calculation that works on full rows.
• Writing one huge formula. Split it into two or three properties so each one stays readable.
• Assuming person and multi-select values behave as text. Formulas 2.0 changed how some references return data.
• Stacking references without counting them. Each reference adds a layer toward the nesting limit.

Formulas 2.0 changes you will notice

Formulas 2.0 added richer return types. A formula can now return pages, dates, people and lists, not only text, numbers or checkboxes. Some old formulas need one edit to get that richer output.

The language also gained local variables with let and lets, dot notation, and new functions such as match() and style(). Use let when one value appears more than once in a formula. That keeps the formula easier to read.

Related databases are also easier to reach. A formula can read a related database directly, without a rollup in the middle. The Formulas 2.0 guide does not give a release date, so don't use it to date your build.

Notion AI, plans, and fixing errors

The formula editor can offer a Notion AI prompt such as Fix the errors in this formula. That prompt is available on Business and Enterprise plans. Notion's pricing page lists Business at $20 per member per month, marked Recommended.

Free and Plus include only a limited trial of Notion AI, and Plus costs $10 per member per month. The pricing page does not mention formulas. You don't need AI to build a working formula, because the manual steps in this guide cover the first one.

Keyboard shortcuts that matter here

No keyboard shortcut creates a formula property. Notion's shortcuts page does not list one for opening database properties either. These shortcuts are the ones worth knowing while you work in a table.

• ⌘/ edits several selected database rows or cards at once.
• ⌘D fills table cells down.
• ⌘R fills table cells right on the shortcuts page. The desktop help page uses ⌘R to refresh the app, so don't mix up the two meanings.

Related guides for your database

If you are still building the database, start with how to create a database in Notion on Mac. Once the formula works, how to filter a database in Notion on Mac shows you how to see only the rows you need.

Sharing a finished database is the next step for most teams. How to share a page in Notion on Mac covers permissions and links. If your data starts in a spreadsheet, how to import csv into notion on mac covers that route.

Next steps after your first formula

Test the formula on a few rows, including one with an empty value. Then check that sorting and filtering behave the way you expect. If anything looks wrong, reopen the editor and read the error before you change the logic.

Work on a copy of a shared database first, so a broken formula never reaches your team. Once the copy behaves, apply the same formula to the original. That order keeps the people who rely on the database out of the debugging.