Skip to content
Get App

The ONLY 5 Notion Formulas You Need To Know

Creative Cove walks through five essential Notion formulas, starting with the Now function, then IF and AND, with step-by-step examples for building a task manager and habit tracker.

Key Takeaways

  • Now() combined with IF and AND enables automatic status indicators such as overdue or high-priority flags
  • Checkbox properties evaluate as true or false and can be summed to track habits or progress
  • dateBetween() and date arithmetic make it straightforward to plan schedules and deadlines

What the video covers

  • Introduces the Now() function as a bonus tool that returns the current date and time and updates automatically
  • Explains the IF and AND functions, comparing them to Excel and describing how each tests conditions
  • Builds an 'Overdue' formula that displays 'Urgent' when a task's due date is earlier than today using IF with Now()
  • Combines IF and AND to flag tasks that are high priority and not yet complete
  • Covers number formulas, including summing checkbox values to create a habit tracker score
  • Shows how to round numbers to a set number of decimal places and format results as percent, progress bar, or progress ring
  • Demonstrates the dateBetween() function to calculate differences between dates in days, weeks, or other units
  • Applies date calculations to project planning by adding durations to start dates to compute end dates
  • Emphasizes that Notion formulas require double equals signs and exact text matches for comparisons
  • Positions these formulas as ways to build more powerful and dynamic Notion workspaces

Answers

Questions about this video

What does the Now() function do in Notion?

The Now() function returns the current date and time. Its value updates automatically, so a formula using it will show the new date when the page is viewed on a later day. It can also be nested inside other formulas to reference today's date.

How do the IF and AND functions work together in the video?

IF checks a condition and returns one value if it is true and another if false. AND checks multiple conditions and returns true only if all of them are true. Combined, they can flag tasks that are both high priority and incomplete.

How is a habit tracker score calculated in the video?

Each habit is a checkbox that evaluates to true or false. Adding the checkbox properties together in a formula counts how many habits are completed, producing a daily total that can be formatted as a number, percent, or progress bar or ring.

Full Transcript — Download SRT & Markdown

00:00
Speaker A
in this video I'll be showing you the top five most useful notion formulas along with several easy to follow examples to show you how they work these formulas are literal game changers and help you build even more powerful notion
00:12
Speaker A
workspaces okay so we're actually going to be starting off with a bonus formula that's going to come in handy throughout this video so it's the Now function which looks like this so it's actually pretty simple so I'm going to show you
00:21
Speaker A
how it works so I'm going to add a formula property by clicking on this plus symbol type in formula and we're going to select this property here and we're actually going to click on this formula edit button here toing bring up
00:30
Speaker A
the panel and this is where we actually are going to type in the formula so if I simply just input the Now function which just looks like this so it's just the word now and an open and close
00:39
Speaker A
parentheses if I just put that and nothing else and click done as you can see here it will then return the exact date and time now this actually updates automatically for you so if I came to this page tomorrow the date would have
00:51
Speaker A
automatically changed to the next date and you can put the Now function inside of other formulas whenever you need to reference today's date so it does come in super handy and you're going to see it several times throughout the video so
01:01
Speaker A
that one was a little bonus and now that you understand how the Now function Works let's move on to our first Formula which is the if and the and functions if you're familiar with Excel formulas then you probably already understand how
01:13
Speaker A
these work they simply test if a certain condition is true or not and then return something based on that output so the IF function will check a condition and it will return a value if that condition is true and it will return a different
01:25
Speaker A
value if the condition is false the and function is similar but it's like a double Checker so it veries if multiple conditions are all true and it will return true if they are or false if at least one of them is false so let's take
01:37
Speaker A
a look at some examples okay so in this table here I have a very simple task manager so as you can see in the First Column we have the name of the task here we have the due date for the task here
01:46
Speaker A
we have the priority level for the task so I've got either high medium or low and then we simply just have a checkbox so I can check off if the task is complete or not so in this table we're
01:55
Speaker A
going to add a couple of formulas using the if and the and functions to display some certain information so I actually want to create a formula that will display the word urgent if the task is overdue so if this deadline has now
02:07
Speaker A
passed it should display the words urgent and I also want a different formula that will display the words high priority if the task is both incomplete so this checkbox hasn't been checked and I also want it to be labeled as high
02:19
Speaker A
priority so we're going to use a formula to do that so let's start with the first one which was to display the word urgent if the task is overdue so we're going to start by adding a formula so I'm going
02:28
Speaker A
to click on the plus symbol here add a new formula and this one I'm just going to call overdue question mark like this and I'm going to click on the formula edit button to bring up our editor so
02:38
Speaker A
for this example we're going to use the if statement so I'm simply going to say if the due date here for the task is less than today's date therefore it's overdue so we want to display the words urgent so let's put that into formula
02:51
Speaker A
terms so we're going to type in if like this I'm going to open a parentheses and we're going to start by putting in the due date so that's this date property here so if you look in this sidebar here
03:00
Speaker A
it does bring up all of the different properties that you've added within the database so I'm going to select the date property here so I want to say if the date is less than today's date therefore if it's less than today's date it's a
03:12
Speaker A
past date therefore an overdue task so I'm going to just use the less than symbol like this and then we're going to input today's date so if you remember the bonus tip that I showed you at the start was the Now function so we're
03:23
Speaker A
going to add that in so it's just now open and close parentheses so all that's going to do is add in today's current date into the formula so we're saying if the date in the date property is less
03:33
Speaker A
than today's date then we're going to add a comma and we're going to tell it what we want to do if this condition is true so we're going to add in two quotation marks like this and inside them that's where we're going to write
03:43
Speaker A
the text that we want to display so in this case I want it to say urgent so I know that any overdue tasks are Urgent we're going to add another comma and finally we need to tell it what we want
03:52
Speaker A
it to do otherwise so if this condition isn't true what do I want it to do so you can add two more quotation marks like this and inside you can write whatever you want want it to say so you
04:01
Speaker A
might want to put not urgent as an example like this so you might actually just want to leave the Box blank so in that case you just want to put nothing inside the quotation mark so you're just going to leave it like this and then
04:11
Speaker A
we're just going to add one more parenthesis at the end to close off the function and that is now complete one thing that I do want to mention is that this Now function can be replaced with another date property so if you have two
04:21
Speaker A
different date properties that you want to reference you can replace that with a different property but in this case I'm using now as I want to reference today's date and once you've written this into the box we can click the done button and
04:31
Speaker A
as we can see in our overdue column it is showing urgent for two of them so today is actually December 6th so as you can see these two are overdue whereas this one and this one aren't so it is
04:40
Speaker A
working correctly and on these ones it is a completely blank box so that is our first Formula all set up and complete and that was using the if statement so the next Formula that I want to add is
04:49
Speaker A
one that is going to display the words high priority if the task is both incomplete and it has a high priority so that's what we're going to do and we're going to use the and function to do that
04:59
Speaker A
so let's add add another formula property on here formula edit and for this to work correctly we do need to combine the if and the and functions together so we're going to start with the IF function so I'm going to type if
05:10
Speaker A
open parentheses and then we're going to add in the and function so that I can add two different criteria so we're going to put and open parentheses so now we can put in the first criteria which is that I want the priority to be high
05:24
Speaker A
so I'm going to select the priority property here from the sideb and that's going to add that into the function so I want to check if the priority is equal to so you want to type in two equal
05:33
Speaker A
signs as that's how notion formulas work and then we're going to write if it's equal to high so I'm going to put two quotation marks like this and inside I'm going to write high so you just want to
05:43
Speaker A
make sure that this word here matches exactly what is written in this column here so if it says high priority you want to write high priority rather than just high so in this case I've written high so that's what I'm putting in here
05:53
Speaker A
we're then going to add a comma and now we need to add in the second criteria that needs to be met for our and function so the second one was that this checkbox here needs to be unchecked so
06:03
Speaker A
we're going to add in our complete checkbox here so that is the name of this property here so I'm going to add that in and in this case it needs to be unchecked so inside a formula if you
06:12
Speaker A
want to write that we're going to write equals equals false so they actually use true and false inside of notion formulas to say if it's checked or unchecked so I want it to be unchecked so I'm going to
06:22
Speaker A
write false but if I wanted it to be checked I would have put true and then I'm just going to close the parentheses and our and function here is now complete so this formula is going to check that both of these criteria are
06:33
Speaker A
true before moving on so now we need to finish off the IF function so this is essentially saying if both of these criterias are true now I need to tell it what I want it to do in that case so I'm
06:44
Speaker A
going to add two quotation marks and inside here I'm going to write what I want it to display so in this case I wanted to display the words high priority comma and then finally I need to tell it what I want it to do
06:54
Speaker A
otherwise in this case I want the box to be blank so again I'm just going to add two quotation marks like this with nothing inside so it leaves a blank box and finally we're just going to close off the parenthesis here which closes
07:04
Speaker A
off this original IF function so that is the completed formula so just to go over once more we're saying if both of these two criterias are true then we want to display high priority otherwise we're going to display nothing and remember
07:17
Speaker A
that both of these criterias need to be true if one of them is true but the other is not true then the result will be false regardless so now I'm going to click done and as you can see here we
07:27
Speaker A
have two that are labeled as high priority so this one is incomplete as this checkbox isn't checked and it is labeled as high and it's the same with this one so there is no checkbox here and it is high but if I check this one
07:37
Speaker A
off as you can see now one of those conditions is not true so the high priority notification has disappeared okay so that is our first Formula so just before we jump back into the tutorial I just want to mention that my
07:48
Speaker A
new second brain template is now available on my store it's a super Advanced all-in-one productivity system I'll leave a link in the description box below if you're interested so that's all back to the tutorial okay and the next
07:58
Speaker A
function that I'm going to show you show you today is the round function so the round function simply rounds Long numbers for you so if you incorporate calculations into your notion databases then it's not uncommon to see numbers
08:09
Speaker A
like this so I've set up a quick example here where I'm counting how many workouts I did this year so this is the number of workouts I did in the year and then I've divided that by 52 to work out
08:19
Speaker A
the average number of workouts that I did per week now this obviously is a really long annoying number so it' be really nice if we could round this number to one or two decimal points and we can do that using the round function
08:30
Speaker A
so let's open up this formula so I'm just going to click on here and edit the property and select the formula edit button so this is the simple formula that I've added in it's simply just the this year property which was the number
08:41
Speaker A
of workouts I've done this year divided by 52 so there are 52 weeks in the year so if I divide this number by 52 it will give me the average number of workouts I did per week which was this number here
08:52
Speaker A
so we're going to use the round function to round the output of this formula so the first thing I need to do is actually just isolate this so I don't actually want to mess with how this for formula
09:00
Speaker A
works so I am going to isolate it using parentheses so I'm just going to add one at the start I'm going to open parentheses and then just one at the end let's close it off this is now isolated
09:08
Speaker A
so that I can't accidentally mess up how it works and we're simply just going to add the round function at the start so if I just type in round like this and click done as you can see here that
09:18
Speaker A
number has now been rounded up so it was 4.9 something something and now it is simply five now this round might be a little bit too dramatic so to round to a specific decimal we actually need to add
09:29
Speaker A
in a modifying number so for one decimal place we use 10 for two decimal places we use 100 three decimal places we use a th000 and so on so you just add a zero for every additional decimal point that
09:40
Speaker A
you want to show so as an example let's round this to one decimal point so I'm going to click on here again edit the property so I want to round this to one decimal point so the modifying number
09:48
Speaker A
I'm going to use is 10 so what we're going to do is I'm going to add another parentheses at the start after round like this and I'm simply going to type 10 and then the multiply symbol which is
09:59
Speaker A
the star symbol like this I'm then going to add another parenthesis at the end to close this off and finally we do need to divide this entire thing by 10 so I'm going to type in forward slash which
10:08
Speaker A
means divide 10 like this and that's all you need to do I'm going to hit done and if we have a look now at the table as you can see that's now been rounded to one decimal point and is now 4.9 so as I
10:17
Speaker A
said we can add another zero to the modifying number if we want to add a decimal point so if I just quickly do that if I change 10 to 100 so both of these are now 100 and click done as you
10:28
Speaker A
can see that's now added one more decimal point for us okay so that is the round function and the third formula that I'm going to show you today is the two number function now the two number function turns various data types into
10:39
Speaker A
numbers if it can do so so this function can turn things like text dates and checkboxes into numbers now this can come in really useful if you want to incorporate something that isn't a number like a checkbox into a numerical
10:51
Speaker A
formula so let's take a look at an example so here we have a very simple habit tracker so we have today's date in the First Column and then I have a checkbox for every habit that I want to
11:00
Speaker A
complete so I can simply just check that off once the Habit is complete now it would be nice if I could add another property that works out the percentage of habits I've completed so I've currently got two habits checked here
11:10
Speaker A
out of four so I'm currently 50% of the way there and we can actually use the two number function to do this so in simple terms what the two number function does is if a checkbox is checked two number will return the
11:22
Speaker A
number one however if it's not checked it will return zero instead so we can use it here to count how many checkboxes have been checked so let's add that formula to start so I'm going to add another formula property here and let's
11:33
Speaker A
just call this one progress and I'm going to click formula edit so I'm going to start typing in two number and you'll see it appear here in the sidebar so I'm just going to select that one and then
11:42
Speaker A
inside the parentheses we're going to start by adding our first checkbox so the first one that I have here is read so I'm going to add that in here so remember that this is going to convert the checkbox into a number so as the
11:52
Speaker A
read checkbox is currently checked this is going to convert the checkbox into the number one so then I'm going to add another one so let's add another two number like this and let's add the next checkbox which was meditate so I'm going
12:04
Speaker A
to click on that one so meditate is currently unchecked therefore it's going to add the number zero and we're just going to add all of the different checkboxes together so I'm going to add another one and so on okay so I've added
12:15
Speaker A
all four of my habits in here using the two number function so I'm just going to click done for now and let's have a look at what it displays so as you can see it's currently displaying the number two
12:24
Speaker A
and that's because two of our check boxes here are checked so if I check another one it goes to three if I check another one it goes to four if I uncheck all of them it goes to zero so as you
12:33
Speaker A
can see it's simply counting the number of check boxes that are checked because the ones that are checked return the number one so it essentially just adds them all together now you actually might want to view this as a percentage so I'd
12:43
Speaker A
prefer if it said 50% rather than two so let's go back into the formula so all we need to do to turn this into a percentage is simply divide the entire thing by the number of checkboxes so I'm
12:53
Speaker A
going to start by isolating it inside some parentheses so I'm going to add one at the end and one at the start this just means that we don't accidentally mess with anything in there and then I'm just going to divide the entire thing by
13:04
Speaker A
four because I have four checkboxes so if you have five checkboxes you want to divide by five and so on and then I'm simply going to click done and we do also just need to change the number format here from a number to a percent
13:15
Speaker A
so that actually displays as a percent and if you would like it to show as a progress bar or a progress ring then you can select one of these options let's go with a progress ring in this case and if
13:24
Speaker A
I just head back to the table here as you can see it's now displaying 50% and we have a nice little ring as well to show our progress throughout the day so if I check off more of these as you can
13:32
Speaker A
see the progress bar increases so that is the two number function and the fourth formula that I want to show you today is the date between function so this works out the amount of time between two dates so there's many
13:43
Speaker A
different units that you can choose from so you can have it work out the number of days between two dates the number of months years weeks quarters hours or even minutes and in this example we're going to work out how many days there
13:54
Speaker A
are between a specified date and today so that we can create a countdown so as you can see in this table in the first First Column I've simply just got the name of something that I want to count
14:02
Speaker A
down to and this property here is the date of that event so I want to create a countdown so I want to work out how many days between this day and today so that I can see that there are I don't know 50
14:11
Speaker A
days to go or 100 days to go until my event so we can use the date between function to do that so let's add another property onto here and let's call this one countdown and formula edit so as I
14:21
Speaker A
said we're going to use the date between function so if you just start typing it it will then appear here in the sidebar so let's go with date between so the first thing we need to do is give it two
14:29
Speaker A
dates so that it can work out the time between those two dates so the first date is going to be the date that we have here in this property so I can simply select the date property here from the list and that will be added
14:38
Speaker A
into the formula and we're going to add a comma and then I need to add the second date so in this case I actually want to work out the time between this date and today so once again we're going
14:46
Speaker A
to use that Now function that I showed you earlier so I'm going to type in now and then open and close parentheses like this but if you have another property in your database that has the date then you
14:56
Speaker A
can just input that property instead but as I said in this example example we're using the Now function we're going to add another comma and finally we do need to tell it the unit so as I said earlier
15:05
Speaker A
you can actually have it work out the years the months the weeks the hours in between two different dates so in this case I want it to work out the days between these two dates so I need to
15:14
Speaker A
tell it that so I'm going to add two quotation marks like this and inside I'm going to write the word days like this so that it knows that I want it to work that out in days so if you just have a
15:23
Speaker A
look here at the information about the function it does list here all of the different units that you can use okay so that is the formul so I'm just going to hit done and as you can see that is now
15:31
Speaker A
working out the days for us now you can take this a step further and add some text onto the end of it so that it would actually look like a real countdown so instead of 183 it would be nice if it
15:40
Speaker A
said 183 days to go so let's add that into the formula so I'm going to click on here edit the property so this part of the property is simply working out the number of days so then we're just
15:49
Speaker A
going to add something onto the end so just add a plus symbol two quotation marks and inside these quotation marks let's write what we want it to say so I want it to say days to go like like this
15:59
Speaker A
and you do also just need to add any spaces in here that you want to display so I want there to be a space between the number and the word days so I'm just going to add a space in here like this
16:07
Speaker A
and just click done and this is what it looks like so as you can see it looks a lot better now and it actually looks like a proper countdown okay so that is the date between function and the final
16:15
Speaker A
formula that I want to share with you today is the date ad function which will simply add a certain number of days weeks months or years to an existing date so it's kind of like saying hey if today is this date then what will it be
16:26
Speaker A
if I add eight days it's really handy for planning schedules or deadlines for a project so I've just set up this example here so firstly we have the name of the project we then have the start date of the project and in this column
16:37
Speaker A
we have the duration of the project so what I actually want to work out is what the end date of the project is going to be so if this is the start date then I want to add the duration of the project
16:46
Speaker A
onto the start date to figure out what date the deadline is going to be we're going to use the date function to do that so let's add another property and I'm just going to call this one end date
16:56
Speaker A
and formula edit so we're going to start by adding in the date add property so you just start typing it you can then select it here from the sidebar so we're going to start by adding the date that
17:04
Speaker A
we want to add something to so in this case it's going to be our start date property so I'm going to select that one to add it into the formula you can also add in the Now function if you want to
17:12
Speaker A
add something to today's date as well but in this example I'm going to be using this date property here and I'm going to add a comma then you need to tell it how much you want to add to this
17:21
Speaker A
date so in this case I've already got this duration property which tells me how much I want to add you can actually also add a number in here so if I want to add for example 10 every single time
17:31
Speaker A
I can simply just add the number 10 in here but in this case it's actually going to vary for the different projects so I'm going to use the duration property so I'm going to add that in by simply selecting it from the sidebar
17:40
Speaker A
we're going to add another comma and then I need to tell it the unit so this doesn't just work with days it can add years months weeks hours minutes here's a list of all the accepted units here so
17:49
Speaker A
I do need to tell it what units I want it to use so in this case I want to use days so I'm simply going to add quotation marks like this and inside just the word days like this so that is
17:58
Speaker A
the formula so I'm going to click done so as you can see it's now displaying the end date so if you just look at this one as an example we had December 15th I wanted to add 10 days onto that so it's
18:06
Speaker A
put the end date here as December 25th which is perfect so that's all set up and working correctly and that's it you can check out all of my pre-made notion templates over on my store including my super Advanced second brain template
18:17
Speaker A
which is an all-in-one productivity system I'll leave a link in the description box below and make sure to give the video a thumbs up and subscribe to the channel if you found the video useful and want to see a part two I
18:27
Speaker A
actually upload new notion tutorials like this one twice a week
Topics:NotionNotion formulasNotion tutorialIF functionAND functionNow functiondateBetweenhabit trackertask managerproductivity

Get More with the SozAI App

Transcribe recordings, audio files, and YouTube videos — with AI summaries and speaker detection. 30 minutes free.

Or transcribe another YouTube video here →