Notion Formulas 2.0 – Advanced Masterclass

In this deep dive, we'll use a bunch of Notion's new formula functions and build something that used to be impossible!

📃 FREE TEMPLATE – Build this example with me:

🎥 CREATOR'S COMPANION (The Best Template for Content Creators - use LETSGO2023 at checkout to get $50 off):

🔗 VIDEO LINKS:

📚 NOTION FUNDAMENTALS (Free & Complete Notion Beginner's Course)

🛠 MORE COURSES AND RESOURCES:

💪GET STARTED WITH NOTION:

🐦Connect with me:
Music ➔ @ThomasFrankMusic

⏱ TIMESTAMPS:
00:00 - Intro
00:23 - Example Project Overview (Videos Database)
00:58 - Another Use Case (Sales Dashboard)
01:38 - Build Start
02:34 - New Formula Editor
04:39 - Lists (Arrays) Tutorial
05:43 - Accessing a Relation's Pages
06:56 - Map Method Tutorial (Most Powerful New Feature)
11:25 - Searching the Relation
13:55 - Variables in Formulas
16:38 - Returning the Top 3 Videos by Views
17:50 - Adding a Second Variable
19:15 - Creating a String from Multiple Values
20:25 - Using the new Style Function
21:52 - Linking to Each YouTube Video
24:40 - Linking to Each Notion Page
26:25 - Truncating the Titles (Regular Expressions)
33:17 - Adding Commas to the View Counts (Regular Expressions)
41:33 - The Final Formula
41:54 - Digging into the Sales Dashboard Example
42:56 - Formula Reference Guide and Tutorial Site
43:54 - YouTube Management Template

🎞 SPECIAL THANKS
Select video clips supplied by Getty Images

[ThomasFrankExplains]

Hey friends! This video is a deep-dive build that will show you how to use a ton of the brand-new functions in Notion Formulas 2.0.


Check that site out if you're looking for more beginner-level content or need a reference for any of the functions while building your own formulas.

HUGE props to Ben Smith on my team, who took on the task of updating all my docs himself. In the near future, we'll add example databases to every function page to make the guide even more interactive.

We're also working on some more formulas-related video content for this channel, along with lots of updates to our templates. This is a MASSIVE new Notion feature, so we've got a lot of work to do to fully take advantage of it.

More videos coming soon!

[GeorgeCockerill]

Such a clear, well-structured and brilliantly produced instruction. Thank you.

[chrisnotion]

Excited to play around with the new Notion formulas, thanks for the video!

[Tthim]

Is this really a video could watch for free?... OMG

[acumenwave]

About 2-3 years ago, I stumbled upon your Notion video on the Project Tasks template, and that's where my Notion journey began. I vividly recall thinking, 'This is the guy I want to watch!' Thank you for being the guiding light in my Notion adventure!" 🚀📚😊

[oukvigb]

Thank you much!
I was struggling for a few days with how to manage Formulas 2.0 and every tutorial on YouTube wasn't deep enought... except by yours!
I really mean it!!!!

[alon_vita]

This new functionality is mind blowing
As always, your videos are precious gold, thank you for taking the time to explain this so thoroughly!

I love how you give real-life examples to make things click quicker and sink in deeply 🔥

[jordannelson]

🎯 Key Takeaways for quick navigation:

00:00 📈 Notion's Formulas 2.0: more powerful formula language.
03:37 🔄 Formulas 2.0 enables list sorting and manipulation.
09:38 🧩 Use "let" function for advanced data handling.
19:16 🧩 Combine text with string concatenation.
20:37 🖌️ Style text using the `style` function.
22:27 🔗 Create clickable hyperlinks with the `link` function.
23:49 📜 Use `join` to concatenate values into strings.
29:05 🪄 Harness regular expressions for advanced text manipulation.
39:49 🧮 Adjust regex for robustness in handling view counts.
42:13 📊 Create complex calculations with Notion's advanced formulas.

Made with HARPA AIt

[autokrim]

Hey Thomas, just a big thank you for your videos and content. Really great work !

[somethingxblue]

This is so insanely good. I'm building my own life management system in notion and I've been using formulas but I realized I was still very limited because I'm definitely not using everything, and I was having a hard time understanding them at times. I can't thank you enough for this.

[GiovannaRibeiro]

YOU ARE A LIFE SAVER!!!!
Thank you so much, Thomas!!

[Douli]

Hello Thomas,
I was struggling with something I knew was possible but the documentation but the documentation was not deep enough on the topic.
It took me 3 hours of head scratch thinking that surely it was possible but did not quite fully understand how to use formula from relation but I found the solution in less than 10 min with your explanation ! Thanks a lot ! Truly a masterclass!

[lifebykaye]

I love that you used Pokemon names to make this easier to understand. You're the best! ✨

[sevestil]

Thank you so much Thomas for explaining! <3

[JimHardie]

Thank you mate! Exactly what i was looking for

[iagorockel]

Great video! I want to point out a better way to put commas into the numbers, the way you showed would work only up to 999, 999, 999, anything else above that would break or would require to add other replace statements into the formula.

Using a single replaceAll("\B(?=(\d{3})+\b)", ", ") expression would work for any number length.

[ireytamich]

Thank you so, so much for explaining in such great detail these updated formulas. I'm a non-technical person, but am too curious to learn more about coding. If I also may say, your voice is quite mesmerizing and the portrayed confidence and intelligence is an assured turn on 😊😅

[RameshKumar-ngnf]

Oh God, i was following your previous channel regularly . I was searching where you disappeared suddenly for more than a year.
I found this new channel today. I wish you updated to all the subscribers in youtube about this. We all missed you.
Subscribed to this channel today.

[alsaukh]

HUGE Update🤩, Amazing Video👌😍, Thank you so much..👋

[susana_yo]

Thomas you’re really out here helping people upskill their careers for free 😭❤️ TY!!!