NOTION FORMULAS 2.0: What You Need To Do Today

Notion Formulas 2.0 are here and it's a massive change. Here's what you need to know to keep using Notion starting today.

Notion just dropped the biggest update in years. Notion has completely revamped their formula language and, effective immediate, has transferred all old formulas (now known as Notion Formulas 1.0) over to a new and improved Notion Formula 2.0 approach.

The good news? All of your formulas will keep working just as before. But if you want to make any change moving forward, you'll need to learn the new formula language.

In this video, I'll share everything that you need to know about this massive update. You'll learn about the biggest changes, why you should have a simple understanding of arrays and most importantly: the most powerful new operators and use cases for Notion Formulas 2.0.

Are you ready to take this next step in Notion's journey?

MY FREE NOTION TUTORIAL 👇🏼

BECOME A NOTION PRO & AUTOMATION AVENGER:
📩 Join 11,000+ tech-loving productivity fans who are levelling up their Notion & Automation skills:

🐦 Twitter

🎥 TikTok

📸 Instagram

💼 LinkedIn

🌍 The Blog

💪🏻 WORK WITH ME

Interested in tailor-made solutions to help your business waste less time and get more done? Send me a message on any channel and let’s have a chat

📣 SPONSOR MY WORK

Interested in getting your product or brand in front an audience of 11,000+ tech-loving productivity fans who who are interested in tools and products that help them lead better lives?

------------------------

Chapters:
00:00 Intro
00:40 Notion Formulas 2.0: The New Editor
01:03 What Notion Formulas 2.0 Can Do
01:35 Step 1: How to Use Notion Formulas 2.0
05:42 Step 2: Understanding Arrays
07:26 Step 3: Notion Formulas 2.0 Use Cases
07:36 Dot Notation
11:19 Using Map in Notion Formulas 2.0
14:15 Using Filter in Notion Formulas 2.0
17:41 Using Length to Replace Rollups with Notion Formulas
19:44 Aesthetic Notion Formulas with Style
22:45 The Most Complicated Notion Formula 2.0 with Find
30:35 Outro

---

Notion and the Notion logo are trademarks of Notion Labs, Inc., and are used here with permission.

Some of the links in this description are affiliate links that help support this channel 😇

[natanribeiro]

🎯 Key Takeaways for quick navigation:

00:00 🚀 Notion has completely reworked its formulas. No need to panic, as old formulas have been automatically converted.
00:29 📝 The new Notion update includes multi-line editing and improved error messages. No more 'prop' and weird quotations, you can now reference properties by their names.
01:11 💡 Formulas now support arrays, variables, and nested access to properties, making them more powerful than before.
01:39 🔄 Most of the approaches and workarounds from the old version will still work with slight tweaks in the new formula language.
03:03 ⏳ Example shown on how to check if a task is overdue using the new formula language.
04:57 🌈 Introduction of the 'ifs' operator, which simplifies multiple conditional checks.
05:51 🔢 Introduction to arrays in Notion. Multi-select, people property, and relations are considered arrays.
07:41 🔗 New DOT operator introduced for chaining commands and accessing system properties.
09:06 📖 DOT command makes formulas easier to read and understand.
11:24 🗺️ Map operator allows you to work with every single item of an array.
14:28 🔍 Filter operator allows you to remove entries from an array based on conditions.
17:53 📏 Length operator counts the length of an array or the letters in a word.
19:56 🎨 Style operator allows you to apply Rich Text formatting to any output.
20:24 📝 Different property types in Notion have unique capabilities, like numbers for mathematical expressions and strings for text.
20:54 🔍 You can create a hidden "result helper" property for calculations, then display the styled result as a string.
21:22 🎨 Use the "style" command to format property values, including bolding and color options.
22:02 🌈 Combine styling with conditional logic to create visually distinct outputs.
23:24 📅 For project management, create a formula to display the next open task with the earliest due date.
24:02 🖋️ Use "let" to define variables in formulas, simplifying complex calculations.
25:36 🧠 Use "find" to return the first true result, as opposed to "filter, " which returns all true results.
27:25 🗓️ Utilize "map" and "filter" to sort an array of tasks by due dates.
28:45 🏷️ Use "join" to concatenate different property values into a single string for display.
30:22 🚀 Advanced formulas in Notion 2.0 offer powerful new possibilities for task and project management.

Made with HARPA AI

[BF-non]

Your production quality has gone up a lot since you started! Good video!

[BlaisZeroni]

This had taught me so much!! I had so much trouble to find an explanation that I (someone with 0% skills in programming) could follow. Thanks for giving us great tools to solve our own notion needs & problems!

[williampegram]

Really well explained Matthias. Thanks. In looking forward to use this!

[panosru]

Long-waited changes!! Awesome news! Thanks for the detailed info!

[TeaWithTash_]

Thank you! An amazing and perfect video! You really helped me wonders!

[ThuLe-zlfk]

This is amazing, thanks Matthias for your well-explained video!!

[BattleofNocebo]

Oh..ooh….oooh! I have sooo much decluttering to do! 😅
And the style possibilities! I’m going to have a lot of fun with this and can’t wait to see what people will create so I’ll want to change it up all over again. It will be glorious! Thank you for working us through and giving us some starting examples!

[KurativeCo]

This is SUPER powerful! dot notations, map, and so many other functionalities are definitely programmer friendly!

[igorcampos]

Matthias, great video! Do you know when this is rolling out to everyone?

[tonyblack]

Thanks Mathias. I can confidently say Notion's now at par with Coda's formula functionality. So excited for this - lots of my template ideas are now possible 🙂

[AnimeFan]

Thank you for the detailed explanation and real-life examples! I'm looking into merging two databases into one calender view and playing around with the new features

[silvansoeters]

Thank you for going so in-depth on formulas 2.0 capabilities. Great video

[Iris-yx]

Congratulations on the video👏. In the "find" part, I wanted to know if there is a way to show more than one task on the same line? Because the video only shows one task, so I wanted to show at least 4 tasks for each project.

[JengibreRallado]

Awesome explanation! Thanks for the early video.

[MartinSchabbauer]

thank you for the very nice and educational video. Love your style as well.

[vladyslavpolonchuk]

Great simple explanation for complex Notion formulas. Keep
going!

[MaxiHawk]

Hi Matthias, finally I couldn't contact you through linkedin but I'm writing you here. As I said, I really like your content and like you, I am a Youtuber of my latin community. I would like to know if I can take some of your examples to make a video about formulas 2.0.

Regards😬

[MichealScott]

❤woah thank you soo much for early updates

[theovitte]

Thank you so much i was suffering to understand some things and your video Was very cool to understand even for à french Guy.