WAKE UP: Notion Formulas 2.0 for Dummies - 6 takeaways, US travel template + Bratz

Hey, 1,994 Notion Rebels- ✨43% of you opened last issue✨ The internet has been EXPLODING with BNE (Big Notion Energy) - here are some of the best bits.

Sep 09, 2023

∙ Paid

🎓 Level up - what are 3k+ #MyNotionSpace course students building?
🔋 Try Notion for free + power up with Notion AI #Notion Partner
💼 Want Notion-trained hires? Post a job ad
🗞 Similar newsletter audiences? Sign up for a free promo swap
🫶🏽 Show off your product? Become a VIP sponsor

Recently, in the Notion Zeitgeist…

Hey! I’m Frances, a Certified Notion Consultant + Founder of The Notion Bar (150+ clients - see my 💌 testimonials, ☎️ coaching + 🎓 course). Enjoy this little curation of what’s new in The Notion Zeitgeist/at The Notion Bar - happy scrolling

If this past week was a GIF, it would be:

I’ve been plotting. Lots of things on the horizon, so stay tuned 👀 Also had a great time speaking on the panel at the Business of Marketing Summit about efficient systems - catch the replays here

Some calm in the productivity storm

Did you know I have a journal community? Every year since 2021, I’ve released an edition of The Happiness Bar journal template filled with wellness tips submitted by YOU to discover + inspire you throughout the year (🍿video). My favourite from this week:

Wellness tip submitters also get early access to next year’s journal 👀

Submit your tip to feature in 2024 →

💼 Job Board

Training new employees in Notion is annoying.
Finding Notion-trained talent is hard.
It doesn’t have to be

Make hiring Notion-trained talent easier & get your job ad in front 2k+ creative & talented global Notion enthusiasts

Hire better talent now →

📰 This week in The Notion Zeitgeist 📰

(*scroll for the hot take)

📺 How do real people use Notion? Explore #NotionStories →

🪩 This week in ✨Profuntivity✨🪩

”Adding layers of fun into your werkflow, while being realistic about what you can actually get done” - future bestseller?!

🍟 How to update 100 year-old branding | 💅🏽 BRATZ X BEYONCÉ | 👗 Legitimately the best clothes upcycling I’ve ever seen | 🛝 Black women reclaiming their hobbies | 🧈 This Kadeem Tyrell song is like butter | 🏃🏽‍♀️ NEED this step class in my city #steppertonhive | 📞 Clubhouse is trying to make fetch happen again

🗃 Archive of my personal ‘profuntivity’ tips’→

Discovered something new?

📣 Tell the world →

🎁 Paid Subscribers this Week 🎁

Scroll to the bottom to join 10 paid subscribers to start your free trial/unlock :

This week’s Notion Flip*: For travellers: 20 best places to live in the US, sorted by overall score and quality of life
30% discount off my paid templates
Confessions of a Certified Notion Consultant: today - baby steps with momentum
All for £4.99/mth

**🔐 *Notion Flips are exclusive pop culture insights/trends flipped into inspiring Notion dashboards. Scroll to the end to unlock the above and our library of flips in our HQ/claim your free trial**

What should I flip next?

👩🏽‍💻 This week at The Notion Bar👩🏽‍💻

Coming Soon: Black Notion Twitter Kickback + Suped up Client Portals + The Notion Blueprint Bootcamp - Build Thoughtful Notion Workspaces

🤓 Clients: Just started building a workspace for an LA-based boutique architecture firm in my VIP day package! Get in on the action and book now | Explore my testimonials →

🎓 Course: 😍 3,113+ students are becoming Notion wizards on the #MyNotionSpace Course

🎧 Latest Podcast Feature: Notion Consultant confessions on No-Code World Radio

🎟 Events: Catch the replay of my panel on Working Smarter as a Marketer @ the Business of Marketing Summit | Catch the replay →

🗞 Let’s collab: Podcast? Interview? Speaking Opp? Let’s chat Notion/profuntivity, tech, culture, entrepreneurship, third culture kid lyfe 🇬🇧🇬🇭🇳🇬 (+🇺🇸) zillennials, surviving your 20s. Explore past features | 💌 Email me →

🎁 Resources: 🔮 What's New with Notion? | 🖤 Black Notion Twitter | 🗞 2 big mistakes you’re making in your Notion workspace | 🎓 Become a Notion Campus Leader

💻 Featured Templates: 📖 The Happiness Bar journal 4k+ downloads | | 💸 Client portal 100+ downloads |📆 Student dashboard 300+ downloads | 🎁 Mega-list of Notion templates →

🧪 Dummies Guide to Notion Formulas 2.0

Notion have upgraded their old formula language to be easier to use and allow even MORE possibilities. If you are a data-science or excel formula nerd, you are about to be hyped. If you’re not, never fear, I’ve put together some resources and inspiration to help you get started.

What’s Changed in Notion Formulas 2.0?

Full release guide + docs here - here’s the “for dummies” summary with examples!

Multi-line editor — instead of one big text block for your formulas, you now have access to a multi-line editor.
1. Game changer for chunky formulas, so ~~I’m~~ you’re not pulling your hair out over where the brackets go.
Tweet →
More outputs — formulas used to only be able to reference text, numeric, and checkbox (boolean) outputs. Now you can also display pages, dates, people, and lists.
1. Game changer for building data outputs that look and feel more connected to your workspace
  Tweet →
Reference more with related databases — when you connect databases to each other using relation properties, you can now ‘read information from the other side’ from the related data e.g. deadlines or tags from projects and tasks can be used in calculation
1. Game changer for reducing the amount of rollups and therefore columns and database bloat in your workspace - faster databases, yay!
  Tweet →
Reference more about the workspace members - so imagine if you tagged a bunch of people in your database and you wanted to automatically pull their email or Full Name - you can do that now.
1. Game changer for doing things like building automatic stakeholder contact information sections in shared portals
BYOV (Build your own variables) - Notion’s new formula has a function called ‘let’, where you can create standalone variables formulas, e.g. calculating this month’s profit. This can then be referenced elsewhere in your formula
1. Game changer as you would have previously ended up having to very clever with your brackets and building separate columns to ‘store’ your calculations
  Help Guide →
Pretty colours - There are now more formatting options which let you add colour, backgrounds, bolding and more to the outputs in your formulas
1. Game changer for building ‘report databases’, as now the key information can jump out to your straight away

Need more help?

Ben also has a Formulas 2.0 course coming out →

How are you going to use the new formulas?

😘 Build prettier Notion Pages

**Level up with 3k+ students on the #MyNotionSpace Course →**

🐣 Beginners learn Notion faster by starting with key principles
🪄 Experienced users elevate their dashboards by learning new hacks

3k+ students | 81+ 👍 reviews | BUILD PRETTIER NOTION PAGES →

🎶 If you are convinced you don’t want to become a more creative Notion thinker, you can still listen to this 00s playlist...🎶

Best Energy,

Frances Odera Matthews | Founder of The Notion Bar & Certified Notion Consultant (✨Artiste✨)

🎁 Time to claim your bonus content! or…

Share ✨ the notion zeitgeist ✨

Keep reading with a 7-day free trial

Subscribe to ✨ the notion zeitgeist ✨ to keep reading this post and get 7 days of free access to the full post archives.