10 Essential Notion Formulas You Should Know & How I Use Them!

This Notion tutorial will show you the 10 most essential Notion formulas you should know to make your Notion setup even better for organising your life! + Try everything Brilliant has to offer-free-for a full 30 days, by visiting brilliant.org/BetterCreating. The first 200 of you will get 20% off Brilliant’s annual premium subscription. You can also find my Notion Life OS templates here: bettercreating.com/lifeos
🎬 WATCH NEXT:
Watch My full Notion Setup Tour 2023 Here: • My Complete Notion Sec...
Notion Buttons Are Here! Awesome Automation Examples: • Notion Buttons Are Her...
I think this is an essential guide to Notion for beginners to make the most of your Notion setup. Time to learn the best Notion formula for your needs!
🎥 VIDEO CHAPTERS:
00:00 The 10 Essential Notion Formulas You Should Know for Staying Productive
00:52 Get Started With Notion Formulas
01:17 1. Doing Simple Calculations In Notion
02:08 2. Notion Date Formulas: How To Use DateAdd & DateSubtract
03:43 3. FormatDate: How To Use The Notion Formula
04:33 4. DateBetween: How To Use Notion Formulas for Calculating Dates
05:08 5. Using the Now() Formula In Notion
05:41 Brilliant for In proving Your Computer Science Skills
07:19 6. Using The Power of If Statement Formula In Notion
08:05 7. How To Use Notion Formulas: Empty()
09:13 8. Using Concat Formulas In Notion: The Ultimate Reporting Tool?!
10:36 9. Using Format() Formulas In Notion
11:55 10. Notion Boss Mode: The Double Concat Formula!
13:16 Going Further with Your Notion Productivity System
➜ FOLLOW ME:
🖥️ Get My Notion Templates: bettercreating.com/downloads
☑️ Get my iOS, iPad & Notion Icon Packs: www.bettercreating.com/iosdes...
📨 Sign Up To my occasional newsletter on productivity & creative life: dashboard.mailerlite.com/form...
📸 Instagram - / bettercreating
🐦 Twitter - / bettercreating1
🌍 www.bettercreating.com
💻 MY FAVOURITE TOOLS:
Get Notion For Free: affiliate.notion.so/bettercre...
Shortform: shortform.com/bettercreating
Orbitkey Desk Gear & EDC: (Use BETTER10 for 10%) www.orbitkey.com/?rfsn=684926...
👋 BETTER CREATING
Hi, I'm Simon and I'm collecting great ideas, tools and tech to help you live your best productive and creative life: On this channel you'll find all things Notion, well designed productive tech, & great ideas on business & self development. Other than doing this, I work as a freelance creative in theatre and film and love motorcycles, coffee and minimalist design.
#notion #productivity #BetterCreating
--
As an Amazon Associate I get a small commission on the product links above at no cost to you! So thanks in advance!
This video was sponsored by Brilliant.

[@BetterCreating]

Happy Friday Pals! Time to go Notion beast-mode!? 😂How are you with Notion formulas? :) 📢+Try everything Brilliant has to offer-free-for a full 30 days, by visiting brilliant.org/BetterCreating. The first 200 of you will get 20% off Brilliant’s annual premium subscription. You can also find my Notion Life OS templates here: bettercreating.com/lifeos

[@Gilly103221]

I have struggled with formulae in Notion after being a whizz in Excel. This video is amazing, cause you have broken big topics into manageable bites. Thank you 🎉

[@BetterCreating]

Love this! Thank you! Exactly the comments I was hoping for! Cheers :) 🎉👊

[@EduardoHenrique-nd1ro]

Thanks for another video, Simon! Happy Friday! Cheers from Brazil!

[@BetterCreating]

Thanks pal! Happy weekend!

[@britirock7]

Great video as always!

[@BetterCreating]

thank you my friend!

[@paulstanley8088]

Great video. Your content is super professional. I love the look-and-feel of your posts and your templates. Thanks for taking the time to do such great work. I find Notion formulas to be "ticky" and I hope that someday they develop an easier way to debug them.

[@BetterCreating]

thanks! My editor works wonders on the video animations too :)

[@jeanschoenlaub3314]

Great video ! I learned so much about how to use Notion formulas to help me manage and organize projects. I'm already putting these tips to use in my project with Riples, a social platform for sharing and collaborating on projects.

[@BetterCreating]

Glad it was helpful!

[@HiMotionAndDesign]

Hello there! Very helpful video! I was trying to find the answer to how I can have a link to a page appear from another database, in a master database, if based on the status of that page. In other words - I have a master inline database, and I want one of the columns to have a link to the "active" project, placed in another database. Thought I could find the answer through formulas, but I might be looking in the wrong place? Can you point me in the right direction for how to solve the problem?

[@STClife]

Thank you Kind SIr 🧘🏽‍♀️👌🏽🧚🏾‍♂️

[@BetterCreating]

No worries! :)

[@generationsarising]

Hi. I am trying to find a way to create a formula where I can make a checkbox checked if two other check boxes are checked. I have a Completed checkbox and a milestone checkbox. I want a way to indicate that a task is a milestone and has been completed. Is there a way to write a formula like this? If so, could you assist me?

[@rallypally]

Hello..thanfor the video..question, I have an excel spreadsheet with dates in timezone GMT+8.. but when I import into Notion, it converts to date in UTC timezone..how can i solve this?

[@arozendojr]

Result of the formula can be a reminder ?

[@DreamPathStudia]

3:57 This video was made a year ago and the format date formula to show days of the week, isn't working anymore. Have you made an updated video? I'd love to check it out, as this was mostly helpful.

[@SimplesmenteSara]

Hi Simon, I´m redoing my notion from scratch and I was watching your videos to understand formulas a little more better bc I hate it and your videos are basically the only way I can navigate through this (thanks btw I love your account ) but now they changed it all and I´m here begging youu to do a tutorial bc I´m totally lost! (ps: english is not my native language so srry if I missedspell smtg)

[@BetterCreating]

Yeah I feel you! Formulas all changed! I will do my best to relearn and then create a new video on formulas asap! :)

[@SimplesmenteSara]

Sorry i didn´t saw your response earlier tysm Simon!@@BetterCreating

[@curtisfamilyadventure]

@@BetterCreating yes please!! I am going through your Notion From Scratch series trying to get set up to begin planning and goal setting for the new year and I am struggling to get the formulas to work :(

[@jaleiaparker1986]

How to put the start and end time on the notion calendar like 10:00- 10:30

[@MondSemmel]

These are some decent formula tips, but I think they would benefit from stressing the upsides and downsides of formatting formulas as text. Namely, you can filter on formulas, sort or group by formulas, or Calculate e.g. the sum of a formula column. And how well you can filter or sort or calculate depends on the data type of your formula. For example, if you want to see all reviews from the current week, then such a filter is easy to setup if your formula is a date, and a pain or impossible otherwise. Similarly, dates and numbers and so on are much easier to sort. Conversely, text may be easier to group. In case you're wondering how one can determine the data type of a formula: it's the data type of the output of your formula, i.e. its outer-most function. So e.g. if that function is dateAdd(), which is depicted as a little calendar icon in the formula editor, then the formula's data type is a date, and it can be filtered and sorted and depicted in a Calendar view like any normal date property. Similarly, if the output is true or false, then the data type is boolean, and the formula is treated like any normal checkbox property.

[@BetterCreating]

Great point to add here! Thanks for sharing. Yes I agree - I usually create a date formula to sort by, and then a second co cat text formula to us as a visual report on a board or calendar view. That way you get the best of both worlds! :)

[@user-xx7nt4wk3k]

I was trying to learn how to calculate a list of numbers from top to bottom, I dont know if notion has a way of doing that

[@BetterCreating]

Sorry not quite sure what you mean here…?

[@jenschristiannrgaard4878]

is it possible to concatenate both text objects and number objects and how would you set this up?

[@jenschristiannrgaard4878]

e.g. country code (UK), label ID (AAA), Year of reference (24), track ID (01) = UKAAA2401

[@BetterCreating]

Yes I believe so: you need to use ‘format(‘ I think for the number properties and then add with + to “text” or reference a property. Hope that solves it for you :)

[@evolutionclouds]

Have you moved to Sydney?

[@BetterCreating]

Haha - no - was on a work trip around Aus - just landed back in UK! :)

[@paninokapatricia3752]

Why when i copy a formula exactly alike from another template it doesn't work?

[@BetterCreating]

Well - you’ll need to check the titles of properties for a start to ensure they are exact to the column names of your database, plus ensure your punctuation is correct.

[@NoName-rp6cx]

tiimeee cooooodeeeesss

[@BetterCreating]

The video has chapter markers - or are you looking for a formula on creating time codes for things in Notion.

[@NoName-rp6cx]

@@BetterCreating I meant timecodes for the video. I didn't have them

[@BetterCreating]

How Strange - they are in the description @@NoName-rp6cx

[@NoName-rp6cx]

@@BetterCreating Really. I'm sorry, I just didn't look there. But for some reason the video is not divided into sections

[@BetterCreating]

@@NoName-rp6cx No worries - I'll see if something is broken I can fix on the description! :)

[@WoahGuyy]

Hey dude, pretty sure it's prop for property, not proposition. But what do I know

[@BetterCreating]

Haha - yeah it very well might be! Well, I like proposing the property - it kind of works when I’m writing the formula!

[@stunt_double]

as soon as I start to focus you move to something next.

[@BetterCreating]

Formulas are complicated - let alone the fact that Notion just updated them to Formulas 2.0. To learn them myself I had to rewatch sections of videos a few times too. Will aim to release a new video on the new formulas asap - a little slower!

[@DrJohnPollard]

Are you Ozzie?

[@BetterCreating]

Haha - no - but recently spent 5 weeks working there. :)

[@The_Explorator]

FYI, It's formulae, not formulas. The latter is semantically incoherent.

[@BetterCreating]

Ok thanks.

[@xqctake8056]

He is expressing an opinion not a fact. The fact is: “formulae” is correct if you’re pluralizing with Latin convention, and “formulas” is correct if you’re pluralizing with English convention.

[@The_Explorator]

@@xqctake8056 That's incontrovertible to some extent, but the fact that the Latin convention is more fundamental, linguistically justifies why its should be given preference over the English one.