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

🎬 WATCH NEXT:

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:

💻 MY FAVOURITE TOOLS:

👋 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.

[Gilly]

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 🎉

[jeanschoenlaub]

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.

[EduardoHenrique-ndro]

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

[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.

[paulstanley]

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.

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

[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?

[arozendojr]

Result of the formula can be a reminder ?

[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?

[jenschristiannrgaard]

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

[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?

[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.

[jaleiaparker]

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

[ArezoRahmani-nc]

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

[paninokapatricia]

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

[WoahGuyy]

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

[stunt_double]

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

[The_Explorator]

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