New Formulas 2.0 in Notion

Notion has just launched one of its most significant updates of 2023: a new formula language called Formulas 2.0.

Combined with native automations and upcoming features, this opens up a world of possibilities, making Notion an even more powerful tool for well-organized businesses.

Let's dive into our first impressions and explore the major changes

A Revolutionary New Editor

The changes to the formula editor are night and day. The previous editor had several limitations:

• Scrolling became cumbersome with long formulas
• Error messages were often unclear
• The rigid structure didn't allow comments or line breaks

The new Notion formula editor brings significant improvements:

1. Expanded workspace (with full-page mode coming soon)
2. Support for formula comments to improve team collaboration
3. Real-time formula result preview, saving unnecessary clicks
4. More fluid overall experience
5. Code editor-like functionality

‍

‍

Welcome to "NotionScript"

Notion didn't just stop at improving the editor – they've created a new formula language inspired by JavaScript, affectionately dubbed "NotionScript" by the community.

For formula enthusiasts familiar with the current language, don't worry. While the syntax has evolved, the core logic remains similar, and the improvements are designed to take Notion to the next level.

Key Innovations

The new language brings several exciting features:

1. Lists (Arrays) Support

• Work directly with related database properties
• Eliminate unnecessary rollups
• Create nested rollups (previously impossible)
• Simplify complex data relationships

2. Variable Declaration

• Use let() and lets() to declare variables
• Reuse variables throughout formulas
• Improve formula readability and maintenance

3. Modern Syntax

• Introduces dot notation
• More intuitive and readable
• Closer to modern programming languages

4. Enhanced Person Property Handling

• Better access to person properties
• Retrieve email addresses and other user data
• Improved user-related computations

5. Style Application

• Apply formatting to formula results:
  • Bold text
  • Custom colors
  • Underline
  • Hyperlinks
  • Background colors

‍

This update represents a significant step forward for Notion, reinforcing its position as a leading workspace tool.

The focus on core product improvements shows Notion's dedication to providing ever-more powerful solutions for businesses and individuals alike.