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.
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.
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 :(
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?
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?
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?
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.