Notion Formulas 2.0 - Live Chat with Notion's Formula Engineers + Demos!

Marie explores the basics and possibilities of Formulas 2.0 with formula expert ‪@benjaminborowski‬ . With special guests Stephen and Yash from the ‪@Notion‬ Engineering team.
////
Notion recently released their new formula engine, which involves a pretty big change in syntax! If you've been struggling with your formulas now that these changes have been implemented, you should join us for this livestream. We'll take questions from the audience and do our best to demonstrate some real-time problem solving by writing some formulas from scratch.
You can catch ‪@benjaminborowski‬ 's Notion Formula 2.0 Overview video here:
• An Overview of Notion ...
And you can learn more about formulas in Ben's upcoming course here:
notionmastery.com/formulas/

[@lwoodman]

This is so wonderfully nerdy, I love it! As a software engineer, this makes Notion feel more appealing than before (I'm coming back to Notion after rejecting it for some years). Would love to know more about your setup, Ben!

[@malglove]

When Notion rolls out big changes like this, it makes me so thankful that I purchased the Notion Mastery course. It was already so valuable to me at the time I signed up, but it continues to be such a great investment. Thank you for all of your hard work!

[@timjeffries-thegoodcup]

really love that solve for filtering out the current page using id() at 52mins Ben. Thanks

[@benjaminborowski]

Cheers!

[@JimShingler]

Would be awesome to see your github workflow that access oura ring API and puts data into notion

[@jdepew]

I second that!

[@solilos]

I’m totally lost! 😂

[@benjaminborowski]

It'll take time! I have decades of programming experience and I still get lost every. single. day!

[@Legendarybeatzonline]

Thank you for that breakdown. I was wondering what are your thoughts on granular database sharing. For example, i have a database for projects and want to share it with my employees so they can see what is in production, but I dont want them to see customer data and pricing. Is there a way to get around this with the new formulas?

[@benjaminborowski]

Unfortunately, no, nothing about the permission model has been changed.

[@Legendarybeatzonline]

@@benjaminborowski is there any talk of making that update next?

[@benjaminborowski]

@@Legendarybeatzonline I've been asking for this weekly for about 3 years. Unfortunately I haven't seen any movement on this type of work on Notion's end. Will keep praying! Haha.

[@Legendarybeatzonline]

That feature would really change the game for notion. At least especially for businesses that use notion for project managment and crm.

[@gmslls]

This THE thing that I've needed most for a couple years in my business!

[@kasperkorea]

Do you recommend to replace all rollups with the new 2.0 formulas?

[@benjaminborowski]

Is the rollup doing its job as-is? No need to replace it. If you want more control, you can replace, but keep in mind that Rollups have extra "rich" displays (for example, multi-selects have color versus being turned into strings in formulas).

[@kasperkorea]

​@@benjaminborowski Thanks, Benjamin. I went ahead and replaced rollups with formulas for more flexibility, but hit a bump on the road when I couldn't use arrays in calculations. A rather disappointing limitation. So, I had to revert to using formatted rollups in these cases. As we all know, Notion takes a big hit to performance when databases get complex. Have you noticed any performance differences between using arrays vs rollup properties?

[@benjaminborowski]

@@kasperkorea why can't you use arrays? feel free to share more. With regards to performance, Notion's engineers has said that Formulas *should* be faster than Rollups, but we don't have any evidence or real way to test this on the consumer end. Anecdotally, I haven't seen any super obvious difference and others have reported the same.

[@benjaminborowski]

@@kasperkorea I haven't noticed any noticable improvement, tbh. Very hard to measure without being a Notion employee though :)

[@breahansen3867]

Was that your Shiba as the cover photo? From the quick glance, they could be twins with mine!

[@benjaminborowski]

No, just shibas from Unsplash 😊