Smart Countdown Formula In Notion - EASY Notion Formulas

🧠 Notion Second Brain Template:

⚡ Get my Notion templates:

In this Notion tutorial, I show you how to set up a clever Notion formula that will calculate the number of days remaining from a due date.

This countdown formula in Notion is perfect for any to-do list, projects or goals databases.

🕝 Timestamps:
0:00 - How the formula works
1:20 - Example database
2:11 - Work out difference between due date & today
3:55 - Turn it into a variable
5:48 - If statements
10:31 - Remove negative numbers
11:13 - Add completed option
12:57 - Add text styling
17:13 - Turn database into a gallery view

[creative_cove]

Update: It appears there is a small bug in the formula where the due date is tomorrow, it shows 'today'. To fix it, you can simply replace the now() function I used in the video with today() and it will work properly 😊

[whyisgamora]

this was probably the best tutorial video i've ever seen, you made everything so easy! thank you!

[lucielenoble]

That was so clear thank you! I've been trying to learn more about coding in notion but found it a bit overwhelming at first. But now that I have found your video I actually am more motivated to learn about it, so thank you!

[baxter]

😀OMG! I just realized that you do not have 1 Million followers. What?!?! 😮You have the best Notion tutorial videos. Easily in the Top 3. 😀 I'm late to the Notion game but with you, I feel like an expert. Thank you for all you do. Please keep it up. I'm so happy that the "YouTube Gods" (aka YT algorithm) sent you to my YouTube feed. And for the rest of us, we need to share, share, share and share you videos. 👍🏻👍🏻👍🏻⭐⭐⭐⭐⭐

[satoruoncrack]

Thank you so much for this comprehensive video! An old notion template that I got from youtube had problems with the formula, so this really helped me fix it.

[alishawoods]

Omg girl yes!!! Thank you so much. Followed your instructions. I love how you break everything down and make it super easy to understand and follow along. Thank you so much!!

[jackfroggoosebear]

Thank you, from this newbie. Modified it slightly to use status==“Done” rather than the checkbox to control “completed”, as I’ve decided to use kanban for my weekly view (I use Jira at work, so love the board view) I am on an iPad though which is a nightmare at times, (e.g. formula window is different, less information displayed, and compressed, table column widths cannot be made narrower, etc!) but you have allowed me to learn some great functionality to compensate for the iPad app/browser frustration.

[gordontucker]

I did it! you explain things very well. Love your content. Helps to have transcript showing to follow along.

[Lina-lorn]

Amazing videos ❤😍
Thanks for the great toturial, keep going..

[sandrafaune]

Exactly what I needed! I'm more familiar with excel and got lost in using the formulas in notion and styling it but this totally helped me out. Thanks a lot and hope to see more vids. Subscribed :)

[SpiderB]

Thank you for this, you have earned a sub from me!

[Vijay-izvb]

I want to do this since very long time but I couldn't .. But wow It is very easy to do.. thank u so much

[kescazuos]

Please please help to do a spaced revision program based on how many questions you get right and wrong!! Pleaaase 😊

[sewkraftysanaa]

Hello this I awesome you have no idea how much your channel has helped me with notions. SO I followed along and this is perfect but I do not have a checkbox. How do I edit this formula for my status property when marked done?

[Jozii]

Thank you for this! 😁

I get one issue though: When the due date is tomorrow, it actually displays as "Today".

I checked the original daysBetween calculation (only displaying the numbers) and if I select yesterday's date it correctly says -1 and today's date says 0. But if I select tomorrow's date it still says 0, and if I select the date two days from now it says 1 instead of 2.

To figure out if I did something wrong when following the tutorial, I counted the days from March 14 to April 30 as in your example, and that's actually 47 days, not 46 as Notion suggests in the video.

I'm guessing this is easily solved by adding a formula to calculate -1 in the "days to go" part of the full formula, but how and exactly where?

I'm completely new to formulas and have no idea where to begin 😅

Regardless, amazing stuff and I'm very happy I found this easy-to-follow video!

[dwikdune]

hi this code is very helfullone question, what if the checkbox is by percentege is that posible ?

[rummantariq]

do you know how can we create Quarterly and Yearly progress bar by using our Monthly progress bars.
Waiting for your response. You showed us how to create a monthly progress bar in your Habit tracker video. But im finding a way in which I can make progress bars for Quarterly and yearly as well. Do you know any Formula for that?

[headstrong]

Hi! I am thinking of doing a count up days with a progress bar. Any idea how do I go about it?

[lakynmartin]

i have the in progress completed and not started status. what would be the code/function in countdown for incomplete and completed?

[ZiLFred_eros]

Do you also think the formula hub could be designed better inside notion? I dont find it handy. Great video though, keep it up!