The Formula Editor

Learn how to write formulas within Notion's formula editor window.

When you click inside the content area of a formula property, you’ll be presented with Notion’s formula editor.

The editor is split into four parts:

  1. The editor field. Formulas written here can now be formatted with line breaks and indentation for readability, and inline comments are also supported.
  2. A live preview of the current value returned by the formula. This will change to a list of errors if any exist.
  3. A scrollable list of all available properties, built-ins, functions, and variables. Clicking one will add it to your formula at the cursor’s current location.
  4. A context window that provides a description of the currently selected/hovered formula component. Also includes a syntax reference and one or more examples.

In addition to clicking formula components (operators, functions, etc), you can also start typing to automatically filter them. Hit enter when the one you want becomes highlighted.

When you’ve finished writing your formula, hit Ctrl/⌘ + Enter to exit the formula editor.

Property references in the new editor are now displayed as tokens. For example, prop("Number") will be shown as Number instead.

Good to know: Outside of the editor, like in documentation like this, you will still see prop("") being used — this is so you can easily copy and paste the examples into the new editor. When copying a formula out of the editor, the pasted version will also contain the original prop("") reference.

If your formula contains an error, you’ll still be able to save the changes you’ve made to it. When there are any errors in your formula, the live preview beneath the editor field will display what those are, and the formula property itself will display nothing.

Learn how to debug your formulas and fix errors:

Fixing Notion Formula Errors – Thomas Frank
thomasjfrank.com

As Notion’s formula editor now supports new lines, indentation, and comments, it’s much easier to write complex formulas without leaving Notion itself.

  • New lines: shift + enter
  • Indentation: tab
  • Comments: /* This is a comment */
About the Author

My name is Thomas Frank, and I'm a Notion-certified writer, YouTuber, and template creator. I've been using Notion since 2018 to organize my personal life and to run my business and YouTube channel. In addition to this formula reference, I've created a free Notion course for beginners and several productivity-focused Notion templates. If you'd like to connect, follow me on Twitter.

🤔 Have an UB Question?

Fill out the form below and I’ll answer as soon as I can! ~Thomas

🤔 Have a Question?

Fill out the form below and I’ll answer as soon as I can! ~Thomas