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.
🎓 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:
💼 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
📰 This week in The Notion Zeitgeist 📰
🆕 Notion Formulas 2.0* | 🆕 New formulas to show top videos* | 🆕 New formulas allow pretty colours* | 🆕 New formulas - quick (📹) examples* | 🆕 New formulas are easier to read | 🆕 How new formulas replace rollups* | 🆕 Upcoming Formula 2.0 Course* | 🇨🇴 Full Casa at Notion Colombia | 👑 POV you build a model portfolio on Notion | 🗺 Maps → mental unblock | 🌯 Lunch @ Notion HQ NYC | 🐶 Notion routine vid with a cute pup |
(*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?
🎁 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.
Game changer for chunky formulas, so
I’myou’re not pulling your hair out over where the brackets go.
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.
Game changer for building data outputs that look and feel more connected to your workspace
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
Game changer for reducing the amount of rollups and therefore columns and database bloat in your workspace - faster databases, yay!
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.
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
Game changer as you would have previously ended up having to very clever with your brackets and building separate columns to ‘store’ your calculations
Pretty colours - There are now more formatting options which let you add colour, backgrounds, bolding and more to the outputs in your formulas
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
🐣 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✨)
📲 TikTok, Twitter, Instagram | 💌 hi@thenotionbar.com | ☕️ Buy Me a Coffee | 🎓 Notion Course | ☎️ Notion Consulting | 🤝 Get seen in this newsletter by 2k+ Notion Rebels
🎁 Time to claim your bonus content! or…
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.