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

[@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!

[@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 :)

[@solilos]

I’m totally lost! 😂

[@benjaminborowski]

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

[@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 😊