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
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 🎉
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.
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.
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?
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.
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?
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 :)
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?
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 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 :(
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.
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! :)
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.
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!
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.
@@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.
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
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 🎉
Love this! Thank you! Exactly the comments I was hoping for! Cheers :) 🎉👊
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.
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.
Glad it was helpful!
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?
Thanks for another video, Simon!
Happy Friday!
Cheers from Brazil!
Thanks pal! Happy weekend!
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.
thanks! My editor works wonders on the video animations too :)
Great video as always!
thank you my friend!
Any tips if I want to create an holiday request form? I want the formula to count only weekdays. Is it possible?
Thank you Kind SIr 🧘🏽♀️👌🏽🧚🏾♂️
No worries! :)
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?
is it possible to concatenate both text objects and number objects and how would you set this up?
e.g. country code (UK), label ID (AAA), Year of reference (24), track ID (01) = UKAAA2401
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 :)
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?
How to put the start and end time on the notion calendar like 10:00- 10:30
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)
Yeah I feel you! Formulas all changed! I will do my best to relearn and then create a new video on formulas asap! :)
Sorry i didn´t saw your response earlier tysm Simon!@@BetterCreating
@@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 :(
Result of the formula can be a reminder ?
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
Sorry not quite sure what you mean here…?
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.
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! :)
Have you moved to Sydney?
Haha - no - was on a work trip around Aus - just landed back in UK! :)
Why when i copy a formula exactly alike from another template it doesn't work?
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.
Hey dude, pretty sure it's prop for property, not proposition. But what do I know
Haha - yeah it very well might be! Well, I like proposing the property - it kind of works when I’m writing the formula!
tiimeee cooooodeeeesss
The video has chapter markers - or are you looking for a formula on creating time codes for things in Notion.
@@BetterCreating I meant timecodes for the video. I didn't have them
How Strange - they are in the description
@@NoName-rp6cx
@@BetterCreating Really. I'm sorry, I just didn't look there. But for some reason the video is not divided into sections
@@NoName-rp6cx No worries - I'll see if something is broken I can fix on the description! :)
as soon as I start to focus you move to something next.
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!
Are you Ozzie?
Haha - no - but recently spent 5 weeks working there. :)
FYI, It's formulae, not formulas. The latter is semantically incoherent.
Ok thanks.
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.
@@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.