**Smart Countdown Formula In Notion - EASY Notion Formulas — Transcript & Summary | SozAI**
Source: https://sozai.app/transcript/smart-countdown-formula-notion-easy-formulas/

Learn to build a smart countdown formula in Notion that shows days remaining, due today, or days overdue for projects, tasks, and goals databases.

## Key Takeaways

- A countdown formula in Notion can be built with date between, now(), and an if statement to show time remaining or overdue status.
- Using let to define variables makes long Notion formulas easier to read and maintain.
- Conditional logic checking the checkbox property allows completed items to show a different status.
- Color styling via dot style improves at-a-glance visual status tracking in Notion databases.

## What the video covers

- Introduces a countdown formula for Notion databases such as tasks, goals, and projects, using a sample projects database with name, due date, and completion checkbox fields.
- The formula displays green when days remain until the due date, blue when the project is due today, and red when it is overdue, with the number of days shown.
- Checking the 'Mark as complete' checkbox changes the countdown display to 'Completed'.
- The presenter mentions a similar countdown formula used in their Second Brain all-in-one productivity template, with a link provided in the description.
- Step one is adding a new formula property named 'Countdown' and opening the formula editor.
- The date between function is used with the due date, the current date via now(), and the units set to days to calculate the difference.
- The let function is used to store the days-between calculation as a reusable variable named 'days between', avoiding repeated code.
- The if function is used to show different text depending on whether the number is positive, zero, or negative, with conditions checked in sequence.
- Absolute value handling is added by multiplying a negative result by -1 to display the number of days overdue as a positive figure.
- The formula incorporates the checkbox property so that completed items display 'Completed', and styling with dot style applies green, blue, and red text or background colors.

## Chapters

1. 00:00 Introduction and Countdown Formula Demo
2. 01:02 Second Brain Template Mention and Database Overview
3. 02:05 Creating the Countdown Formula Property
4. 03:00 Using Date Between and Now Functions
5. 04:03 Storing Variables with Let
6. 05:36 Adding Conditional Logic with If Statements
7. 07:03 Handling Overdue Dates and Completed Checkbox
8. 08:00 Styling the Output with Colors

Answers

## Questions about this video

What does the countdown formula display for different due dates?

The formula shows a green countdown of days remaining for future due dates, 'due today' in blue when the due date is today, and a red count of days overdue for past dates. Checking the complete checkbox changes the display to 'Completed'.

Which Notion functions are used to build the countdown formula?

The formula uses date between to calculate the difference in days, now() to reference the current date so it updates automatically, let to store the calculation as a variable, and if statements to choose the displayed text. Dot style is used to apply colors.

How can this countdown formula be applied to an existing database?

Start with any tasks, goals, or projects database that has a date property, add a new formula property, and build the formula step by step using the date between, now(), let, and if functions. The presenter also notes that the formula can be used in gallery view.

## Full Transcript — Download SRT & Markdown

00:00

Speaker A

in this video I'll be showing you my easy countdown formula in notion that is a great addition to your tasks goals and projects databases so here we have an example projects database that I've set up just for the purpose of this video so

00:12

Speaker A

it's quite a simple database we just have the name of the project the due date for the project this is the countdown formula that I'm going to be showing you how to build today and then simply just a checkbox so that you can

00:22

Speaker A

mark the project as complete once you're done so as you can see the countdown formula looks a little bit different on the different projects and that's all because of the due date so if the due date is in the future it will show a

00:32

Speaker A

green countdown like this and it will count down how many days to go until the due date for the project if the due date is today so today for me is March 14th so if it's today it will show due today

00:41

Speaker A

in blue and if the date here is a past date then it will show in red and it will tell you how many days overdue the project is another really cool thing about this formula is that if you check

00:51

Speaker A

off the markers complete checkbox it will then change to completed now I do actually have a really similar countdown formula on my second brain template which is an all-in-one productivity system so I actually use this formula on my

01:02

Speaker A

projects and goals databases so as you can see it displays here on these cards and if you are interested in this template at all then I will leave a link in the description box below where you can grab it and in the rest of this

01:12

Speaker A

video I will be showing you how to create this countdown formula here from scratch and how you can apply it to your existing tasks goals or projects databases okay so I am starting off with a really simple database so I'm sure

01:23

Speaker A

most people watching this video already have a database similar to this so as I said it could be a task or a to-do list database a project Project's database like this one or even a goals database so in the First Column I've simply just

01:35

Speaker A

got the name of the project in this case we've got a date property here where I've inputed the due date for this project and I've also just added a check box here so that I can check the project

01:44

Speaker A

off once it is complete so this is the database that I'm going to be using today and we're simply just going to add that countdown formula onto here and I'll also show you how we can change it into the gallery view that I showed you

01:54

Speaker A

in the example so the countdown is actually a formula so we're going to start by adding a new formula property so you can just click on this plus symbol here type in formula and select this formula property and I'm just going

02:05

Speaker A

to give this the name of countdown we then just want to click on the formula edit button here to bring up our panel and this is where we're actually going to type in the formula so the first thing that we actually want to do within

02:14

Speaker A

this formula is we actually want to work out the difference in days between our due date and today so that's going to give us the countdown so to do that we can actually use the date between function so I'm simply just going to

02:25

Speaker A

type in date between like this and then you can grab it here from the sidebar so it's date between now as you can see here it gives us a little description of what the date between function does so

02:34

Speaker A

it says that it Returns the difference between two dates and the units can be either years quarters months weeks days hours or minutes so as I said in this case we're going to use days because I want to work out the days between now

02:45

Speaker A

and our due date so you can simply just type in the two different dates that you want it to work out the difference between and then just the units so the first date that we want to put in here

02:55

Speaker A

is our due date so if you look in the properties here it's going to bring up all of the properties within the table so I'm going to start by by grabbing our due date and putting that in here we're

03:02

Speaker A

then just going to add a comma and now we need the second date to be today's date so obviously that's going to change every single day so we actually just want it to be able to reference whatever today's date is so we can actually use

03:12

Speaker A

the Now function so you just want to type in now and then two parentheses like this and that is going to reference today's date so this will update automatically every day so it's quite useful we're going to add another comma

03:23

Speaker A

and the final thing we need to put in here is the units so we're going to add two quotation marks like this and inside we're just going to type days so this is just telling this function that we want

03:32

Speaker A

it to work out the difference between these two dates in days so if I actually just click done at this point let's see what we have so this is what we currently have so it does appear to be

03:41

Speaker A

working correctly so as I told you today is March 14th which is why this one is zero this one is a past one so it's showing minus 14 and this one is a future date so it is working correctly

03:50

Speaker A

so let's open it back up so I'm just going to click on here edit the property and I'm going to click formula edit so we will actually be referencing this number so the number of between our due date and now quite a lot throughout the

04:03

Speaker A

formula so I don't actually want to have to type this out every time I want to reference this number so we can actually turn this into a variable which in notion just means that I can give this function here a code name and whenever I

04:14

Speaker A

mention that code name notion will know that I mean this piece of code so I therefore just don't have to type it out every single time so we can actually use the let function to do that so right at

04:23

Speaker A

the start I'm just going to type the word let and then open a parentheses and I'm just going to close it at the end and for this final parentheses I'm actually going to place it on the next line so I'm just going to place my

04:32

Speaker A

cursor here just before the final parentheses hold down shift on your keyboard and I'm just going to hit enter twice now the reason we're doing this is because we are going to add some more code in this Gap here and it just makes

04:42

Speaker A

it a little bit easier to read if we have it on separate lines like this so that's why we're doing that now the final thing we need to do with this bit of code here is we actually need to give

04:49

Speaker A

it the code name so in this case I'm just going to call it days between so right here just before the piece of code I'm just going to type in days between like this and a comma so this here is

05:00

Speaker A

the name of the variable or the code word that I can use throughout the rest of the formula to reference this piece of code here so this is going to save us a lot of time later on so if I click

05:10

Speaker A

done at this point as you can see there's now nothing showing in that box and that's because I don't actually have anything in the formula anymore I'm simply just saying here that days between means this I'm not actually

05:19

Speaker A

telling it to display anything in the box so just to show you how this works I'm just going to add a comma here and then just in the blank space here I'm just going to type in days between so

05:27

Speaker A

what I'm doing here is I'm essentially just calling this piece of code so I'm saying let's just grab the days between so the days between is this piece of code which as I showed you works out the number of days between now and our due

05:37

Speaker A

date so I'm calling this piece of code here so if I do that and click done as you can see it's now bringing up that number again so we have managed to set up this days between variable correctly

05:47

Speaker A

so I can just remove that now next we're going to be using the IF function so that we can actually display something different in the Box depending on the due date so if the due date is in the

05:56

Speaker A

future I want it to say something along the lines of 46 days to go however if the due date is today then I want it to say something like due today and if the due date is a past date then I want it

06:06

Speaker A

to say something like 14 days overd so we actually want to use the IF function to do that the IF function will simply test a condition and will return one value for true and another for false let's look at an example so we could say

06:18

Speaker A

something like if the checkbox is checked then display the word complete otherwise display the word overdue so applying that to our example as I said we are going to be using some if statements to produce a different output

06:30

Speaker A

depending on if the date is in the future in the past or today so we are going to be using multiple if statements to make this work so we're actually going to be using the ifs function so it's ifs like this and I'm just going to

06:42

Speaker A

open and close a parentheses and just as we did earlier I'm just going to place my cursor in between them and I'm just going to hit shift enter so that this one goes to the next line but that's

06:51

Speaker A

just because we are going to be writing three different statements in here so I just want to place one on each line so that it's nice and easy to understand so the first condition that we want to add

06:58

Speaker A

in here is if this number here is a negative number therefore it's a past due date so we actually want to type something along the lines of 14 days overdue so let's put that into a statement so what we're going to do is

07:10

Speaker A

we firstly need to grab our days between number cuz that's the number we're checking if is negative so I'm just going to call our days between variable like this so I'm calling this piece of code here and we want to check if this

07:23

Speaker A

is less than zero if it's less than zero it's a past due date so I'm going to add a comma and now we need to tell the formula what we want it to do if this condition is true so if it's true I want

07:33

Speaker A

it to display the number and then I want it to say days over due so again we can just grab the days between number again so I'm just going to type in days between we're going to add a plus symbol

07:44

Speaker A

like this and two quotation marks and inside here I can type in the actual words that I want to display afterwards so we're going to add in a space so that there is a space between the number and

07:53

Speaker A

the text and I'm just going to type days overdue and we're just going to add a comma as well at the end so that is our first statement so I'm just going to hold down the shift key on my keyboard

08:02

Speaker A

and hit enter so that we go to the next line and we can actually write in our next condition here so the next condition that we want to account for is if the days equal zero so if it's zero

08:11

Speaker A

therefore it's today so we want it to say due today so we're going to type in days between to grab our days between number equals equals z so we're checking here if this number is equal to zero you

08:23

Speaker A

do need to put two equal signs in notion formulas a comma and again we just need to tell it what we want it to display so in this case we don't need to grab the number like we did in this one we just

08:32

Speaker A

want it to display the Text due today so we're going to add two quotation marks and inside I'm just going to put due today and let's just add an exclamation mark as well and you do need to add a

08:41

Speaker A

comma right at the end here as well now the next condition is if the number is more than zero therefore it's a future due date so we want to say something like 46 days to go so again shift and

08:52

Speaker A

enter to go to the next line and I'm going to type in days between and this one is going to be if days between is more than zero comma and then we need to tell it what we want it to display so

09:03

Speaker A

again I need to actually grab the days between number so it would display the number 46 in this case so let's type in days between the plus symbol and two quotation marks and inside we can type in the text so we need to add a space so

09:15

Speaker A

that there is a space between the number and the text and I'm just going to type days to go and just remember to add a comma at the end of this line so those are all of the conditions that we want

09:24

Speaker A

to check but with notion formulas you can also give a otherwise option so if actually not of these are true then what do you want it to display in that case so in our example if none of these

09:35

Speaker A

conditions are true therefore the due date must be empty that's the only other option so if the due date is empty I think it would be useful to say something just like set due date so that I can see easily that I actually need to

09:46

Speaker A

set a due date so we're going to hit shift enter again and in this case you don't need to type in any conditions you just need to say what you want it to display if none of the conditions are

09:55

Speaker A

true so I'm just going to add in two quotation marks and let's just write the word set due date so therefore if the due date is empty it will just display in this box set due date so I know what

10:04

Speaker A

to do and let's just add an exclamation mark as well and you don't need a comma after this one because it's the final thing in the formula okay so at this point let's click done so I can show you

10:14

Speaker A

what we have so here is our database let me just make that a bit wider so is starting to now look a little bit more like what I showed you at the beginning so in this one it's a future due date so

10:23

Speaker A

it's saying 46 days to go this one is today's date so it's saying du's today this one is a past date so it's telling me how how many days overdue it is which is really nice now the main issue that

10:33

Speaker A

I'm seeing at this point is that for this past due date one is displaying minus 14 days overdue and I'd rather it just say 14 days overdue so we can get rid of this negative Mark here so let's

10:43

Speaker A

just click on here and edit the property again so we want to have a look at the first condition here as this is the one that is creating the days overdue and all we need to do is actually just

10:52

Speaker A

multiply the Min -14 number by -1 and if you multiply a negative by a negative it just turns into a positive so this days between here is actually generating this minus 14 number so I'm just going to put

11:04

Speaker A

in the star symbol which means multiply and I'm just going to multiply by minus one so if I just click done as you can see it's literally all that's doing here is just removing that negative sign the next thing that I want to do is if you

11:15

Speaker A

remember in the example once you actually check the completed checkbox off it would actually change the text just to the word completed because I think that would be useful if you have completed the project or the task you

11:25

Speaker A

just want this to disappear I don't want to be able to see how many days overdue it is if it is already complet Ed so we're going to add that in so let's just click back on here and edit the property

11:34

Speaker A

so all we need to do is actually just add one more condition in our if statements to say if the complete checkbox has been checked then just display the words completed now we do actually have to add this as the first

11:45

Speaker A

condition so we're just going to place our CER here shift enter and I'm just going to add it right at the top here now the reason that you have to add it right at the top is because with notion

11:53

Speaker A

formulas if statements follow a hierarchy so if something meets multiple conditions it will always follow the rule of the the first condition that it meets so if you add it at the end then it will probably have followed one of

12:03

Speaker A

these other rules first so for this if statement we firstly need to add in our checkbox so that we can check if it's checked or not so you'll actually find the properties here in the sidebar so I've called this one markers complete so

12:14

Speaker A

I'm just going to add in the checkbox property and we're going to check if it is checked so I'm going to type in equals equals true now true is used to check if the checkbox is checked and false is used to see if it is unchecked

12:26

Speaker A

so this is essentially just saying check if the Mark is complete check box here is checked so I'm going to add a comma and then we need to tell it what we want it to display in the box if this

12:35

Speaker A

condition is true so if the checkbox is checked then we can just display the words completed and let's just put an exclamation mark and don't forget just to add a comma at the end here so there should be a comma after every single

12:46

Speaker A

statement apart from the last one here so I'm just going to click done so let's see if this works so if I check off this one as you can see the text changes to completed so it is working so the next

12:58

Speaker A

thing I want to add to this is some Style L to the text so if you remember in the example it would be green for days to go Blue for due today and red for days overdue so let's add that in so

13:07

Speaker A

again let's just go back here and edit this property so I'm going to start by adding some styling to all of the outputs so the first thing we're going to do is right at the end after this final parenthesis here I'm just going to

13:17

Speaker A

type the words do style and this allows us to add styling to the text and you just want to open and close a parentheses and inside we're going to tell it what we want to do so the first

13:26

Speaker A

thing we're going to do is add code styling so if you actually just put two quotation marks like this and a c that's going to add code styling which essentially just adds a box around it so let me just click done at this point so

13:37

Speaker A

this is what code styling looks like if I just go back in here I also want to make the text bold so if I just write a comma in here two more quotation marks and a b b stands for bold so if I click

13:48

Speaker A

done as you can see the text is now just a little bit thicker the next thing we want to do is actually change the colors for each individual output so let's go back into our formula so let's start

13:56

Speaker A

with the completed one at the top so I want this one to be green so I want the text to be green and I want the background to be a lighter shade of green so what we need to do is just

14:05

Speaker A

before this final comma here we're just going to go in here and type in our DOT style open and close parentheses and inside we're going to tell it the color so I'm going to put two quotation marks like this I'm going to type green now

14:16

Speaker A

this is referring to the text color I'm going to add a comma two more quotation marks and this one is going to be green underscore background and this one is referring to the background color so if I just click done at this point let's

14:29

Speaker A

show you what that looks like so I'll check this check boox and it changes now so as you can see the text is green and the background is a lighter shade of green so these are just Notions automatic colors so is quite good at

14:40

Speaker A

automatically picking out the right colors for you so let's go back into the property next let's move on to the next line and this one is the days overdue so I want this one to be red text with a

14:50

Speaker A

red background so just before that comma there we're going to type in dot style open and close the parentheses now this one as you can see is already default red Tex so I I don't actually need to change the text color I actually just

15:01

Speaker A

need to change the background color so I'm going to type in two quotation marks and redcore background to add the red background color for the due today I want this one to be blue text with a blue background so again just before the

15:14

Speaker A

final comma we're going to type in do style open and close parentheses two quotation marks and inside we're going to write blue and that is referring to the text color going to add a comma and again two quotation marks and this one

15:27

Speaker A

is going to be bluecore for background and that's going to be for the background color for the days to go this one I want to be green so just before the final comma I'm going to add dot style like this two parentheses and

15:40

Speaker A

inside we're going to do two quotation marks and I'm going to type in green and that's referring to the text color a comma two more quotation marks and this one is going to be greencore background and for the final set due date option

15:53

Speaker A

I'm just going to leave it as it is so it'll just display red with a gray background now one other thing we need to do before we hit done to make this work is we do actually need to isolate a

16:01

Speaker A

couple of items in here so let's take a look at this one so because I've added the dot style here at the end this is only actually going to be applied to the days overdue and it's not going to be

16:11

Speaker A

applied to the number so if I actually isolate this inside parentheses it will be applied to the entire thing so just here before the days between we're going to add a parentheses and then just here after this quotation mark but before the

16:23

Speaker A

dot style we're going to add one more so this is essentially just kind of packaging this all together into one item and and then the dot Style with a red background is going to be applied to the entire thing and not just this piece

16:34

Speaker A

of text here so this one and this one we don't need to alter cuz there is only one element here as you can see so this one again is the same there's just one element but this one here is two

16:45

Speaker A

elements we have the days between and then the days to go so I do need to do the same thing so one parentheses here at the start and then one here just before do style let's hit done and just

16:55

Speaker A

check that this is all working correctly let me just uncheck this one so this one is the future date so it does say 46 days to go and it is the green color this one is the blue color and this one

17:05

Speaker A

is the red color so it does seem to be working correctly let's just add a new blank one and as you can see it does come up just telling me to set the due date in that case so that is our formula

17:14

Speaker A

all set up all complete the final thing that I want to show you how to do is change this into a gallery view cuz it looks just a little bit nicer I think as a gallery view so to do that you can

17:23

Speaker A

click on the three dots here we're going to select layout and I'm going to change it to a gallery view and the first thing I want to do here is just change the card preview to page cover and I did

17:33

Speaker A

actually add a cover photo for each of these projects earlier but you can do that yourself and you can also change the card size if you want it to be bigger or smaller but I'm going to leave it as medium for now let's just click

17:43

Speaker A

back and go on properties so I want to show these properties on the card so let's start with the due date so I can see when the project is due We'll add our countdown formula and we'll also add

17:52

Speaker A

the complete check boox so this is now what it looks like you can add as many of these projects as you like and if you change the the due date let's just change it for a little bit further as

18:02

Speaker A

you can see it will automatically update the countdown and if you Market is complete it changes to completed so it's a really really handy system that you can add to any task to-do list project or goals database and that's it you can

18:14

Speaker A

check out all of my pre-made notion templates over on my store including this super Advanced second brain template which is an all-in-one productivity system and if you found this video useful then I'd really appreciate if you could give the video a

18:25

Speaker A

thumbs up and subscribe to the channel as I upload new notion tutorials every week we

Topics: Notion Notion formulas countdown formula Notion tutorial productivity project management date between Notion database task management Second Brain

Study this video

- [Flashcards from this video](https://sozai.app/tools/flashcard-maker/#from=transcript&id=94401)
- [Quiz on this video](https://sozai.app/tools/quiz-generator/#from=transcript&id=94401)
- [Crossword from this video](https://sozai.app/tools/crossword-maker/#from=transcript&id=94401)
- [Word search from this video](https://sozai.app/tools/word-search-maker/#from=transcript&id=94401)
- [Study guide from this video](https://sozai.app/tools/study-guide-maker/#from=transcript&id=94401)

Free, made by AI from this transcript. No signup.


---
This is the markdown twin of https://sozai.app/transcript/smart-countdown-formula-notion-easy-formulas/ — the same content, without the markup.
Published by SozAI (https://sozai.app). Reuse and quotation are allowed with attribution and a link back.
Machine-readable index: https://sozai.app/llms.txt · data API: https://sozai.app/api/
