Smart Countdown Formula In Notion - EASY Notion Formulas

🧠 Notion Second Brain Template:
creativecovehq.etsy.com/uk/li...
⚡ Get my Notion templates:
creativecovehq.etsy.com
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 😊

[@sandrafaune4324]

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 :)

[@creative_cove]

You're very welcome! Thanks for subscribing :)

[@satoruoncrack9250]

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.

[@RodGomez1]

Thank you. This was super helpful.

[@alishawoods5336]

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!!

[@creative_cove]

You are so welcome! Thanks for watching 😊

[@o_wrzosowa]

Girl, you helped me a lot! Love ya ❤

[@creative_cove]

You're so welcome! 😊

[@jackfroggoosebear3187]

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.

[@gordontucker055]

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

[@creative_cove]

You're welcome, thanks for watching! :)

[@anickglobensky-bromow9820]

Simple and easy to follow!

[@creative_cove]

thank you!

[@Lina-lorn]

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

[@creative_cove]

Thanks, will do!

[@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?

[@putrisidestory]

Thank you so much girl

[@creative_cove]

You are so welcome!

[@Vijay-iz4vb]

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

[@smruti_ranjan_gansalvesh492]

Thanks a lot ❤

[@creative_cove]

You're welcome 😊

[@harold.machado]

Thank you.

[@creative_cove]

You're welcome! Thanks for watching :)

[@ramonablasius9748]

Thank You

[@creative_cove]

You're welcome! 😊

[@fredericgoeller3567]

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

[@Jozii89]

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!

[@creative_cove]

Apologies, you're right! The issue is because I used the now() function which pulls through the date & time of today. This caused a problem because if it's less than 24 hours until tomorrow begins then it's counting that as one day less (hope that makes sense). To fix the issue, you can just replace the now() with today() instead which just pulls through today's date and not the time as well. So the first part of the formula would become this: let(daysBetween, dateBetween(prop("Due Date"), today(), "days"), Thank you for pointing this out! :)

[@Jozii89]

Aha, makes perfect sense! Thank you so much for the quick reply 😊

[@RuskingGonzalez]

LOOKING FOR THIS! 🎉 THANKS!

[@ingriderthalmartinez8671]

How do I add hours, minutes and seconds left to this formula? Thank you so much for the content.

[@rummantariq7459]

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?

[@headstrong1810]

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

[@gwuevve]

Thank you so much for this! I was struggling to keep up with my tasks and to pressure myself in doing them and this was truly helpful. Btw, do you have any solution on how to change 1 DAYS ago to 1 DAY ago? Thanks in advance!

[@creative_cove]

You're so welcome! For the 1 day, you can include another if statement in the formula. So it would say if(daysBetween == 1, (daysBetween + " day to go").style("green", "green_background"), Make sure you add it into the formula before the daysBetween > 0 line to make sure this one gets priority.

[@gwuevve]

@@creative_cove Hello, thank you so much for the help! Also, is it okay to ask another question? I also want it to show "1 day overdue" but I don't know how to formulate it. Again, thank you so so much for help! 💗

[@dwikdune5212]

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

[@lisa.de_m]

Thank you for your vidéo, you helped me a lot ! I was so frustrated with one formula in particular ^^ But now I don't know if I'm the only one to have this probleme, but the due and past date aren't quite correct. I mean : We are the 22nd, I put a dealine to 23rd, and it says : Deadline today. But the deadline is tomorrow. I tried - 1 and + 1 but it's isn't correct either. Is it normal ? Thank you in advance for your reply ! And thank you again for you video :)

[@creative_cove]

Hi, you just need to replace the now() function within the formula with today() instead. It was a small mistake I made in the video, sorry! now() also includes the current time so if tomorrow is less than 24 hours away, it's counting it incorrectly as today whereas the today() function just includes the date and not the time.

[@lisademeyer4843]

@@creative_coveyou’re right, it works, thank you very much ! ☺️

[@lifebykaye]

Love the colors! Just one question, I followed everything and got stuck at my due date tomorrow being displayed as today. Any idea why this happens?

[@creative_cove]

It's due to a small bug with the now() function that I used, sorry! To fix it just replace now() with today() instead and it will work properly.

[@lifebykaye]

@@creative_cove thank you so much! you're an angel 🥹

[@zyaxczya]

how about when my property is status instead of checkbox?

[@creative_cove]

In that case, you could just change the if statement to something like if(status == "complete"), "Completed!"

[@kelleighedwards5370]

im having trouble adding more space to the output between the days and the text

[@creative_cove]

You need to manually add in a space just before the text within the quotation marks else it won't add one.

[@user-xv4jz9tb6t]

I have a problem, when due date is tomorrow the formula shows Due Today! How can i fix that

[@creative_cove]

Sorry it was a small bug in the formula. Please replace the now() function with today() instead and it will work 😊

[@TiaSMuthmainah]

Why, in my notion "Mark as complete" do not appear?

[@creative_cove]

It’s something I added myself. You just add a checkbox property and name it ‘Mark as complete’ 😊

[@ALPuneeth]

🎈

[@user-jb9zy9he8x]

I using property status..how can show complete!?

[@user-jb9zy9he8x]

Can you show me complete formula

[@creative_cove]

You'll just want to change the top if statement to something like if( status == "Done", "Completed!" You'll need to make sure 'status's is replaced by your status property and 'Done' should be replaced with the exact text you're using inside the status property for complete tasks.