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

Рет қаралды 32,817

Күн бұрын

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.

Пікірлер: 50

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

@jeanschoenlaub3314 7 ай бұрын

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 7 ай бұрын

Glad it was helpful!

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

@britirock7 Жыл бұрын

Great video as always!

@BetterCreating Жыл бұрын

thank you my friend!

@STClife Жыл бұрын

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

@BetterCreating Жыл бұрын

No worries! :)

@HiMotionAndDesign 10 ай бұрын

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?

@DreamPathStudia 10 күн бұрын

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 9 ай бұрын

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 9 ай бұрын

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

@SimplesmenteSara 8 ай бұрын

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

@curtisfamilyadventure 6 ай бұрын

@@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 :(

@generationsarising 11 ай бұрын

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?

@arozendojr 9 ай бұрын

Result of the formula can be a reminder ?

@rallypally 2 ай бұрын

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?

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

@jaleiaparker1986 3 ай бұрын

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

@user-xx7nt4wk3k 6 ай бұрын

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 6 ай бұрын

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

@NoName-rp6cx 9 ай бұрын

tiimeee cooooodeeeesss

@BetterCreating 9 ай бұрын

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

@NoName-rp6cx 9 ай бұрын

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

@BetterCreating 9 ай бұрын

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

@NoName-rp6cx 9 ай бұрын

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

@BetterCreating 9 ай бұрын

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

@evolutionclouds Жыл бұрын

Have you moved to Sydney?

@BetterCreating Жыл бұрын

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

@paninokapatricia3752 11 ай бұрын

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

@BetterCreating 11 ай бұрын

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.

@WoahGuyy 11 ай бұрын

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

@BetterCreating 11 ай бұрын

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 10 ай бұрын

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

@BetterCreating 9 ай бұрын

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 8 ай бұрын

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

@BetterCreating 8 ай бұрын

Ok thanks.

@xqctake8056 6 ай бұрын

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 6 ай бұрын

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