Smart Countdown Formula In Notion - EASY Notion Formulas

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

[@maramstudies560]

Thanks :)) very helpful video dear

[@maramstudies560]

Can you please help me with something? Today() is not defined for me, they tell me today is not defined, what do i do? Thanks

[@ryantheawesome7187]

@@maramstudies560 its a lowercase t :)

[@dwyquish1709]

I've been using Notion since the pandemic and oftentimes it's hard to keep with the changes. So, thank you so much for making this in-depth tutorial!

[@creative_cove]

You're so welcome!

[@argemations]

I have never appreciated a tutorial as much as I have this one. Thank you for your hard, thorough work! What a great introduction into the world of notion coding

[@creative_cove]

You're very welcome! Thank you for watching 😊

[@russellmaynard5127]

Fully Agree. I really like the clarity and pace of the instructions. Right to the point, easy to follow. I have subscribed. Well done

[@lucielenoble2795]

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!

[@creative_cove]

Glad it helped!

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

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

[@alexparker1958]

Beautiful, just what I needed, thank you!

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

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

[@wiggertvanameijde4584]

Your videos are so amazing! I really like the deep explanation and the ´how it work´ explanation. where did you learn how to code?

[@whyisgamora3263]

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

[@creative_cove]

You're very welcome!

[@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! :)

[@GerrenNtiri]

So so useful and well explained, thank you so much!!

[@creative_cove]

Glad it was helpful!

[@JubranZakri]

This lesson is worth a Million Thanks and Likes.

[@creative_cove]

Thank you! I'm glad you enjoyed it 😊

[@BrownSugaBabe84]

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 😊

[@jeepers.creeker]

There's a slight problem where, if the due is just before/over one day, it still shows "1 days overdue/1 days to go" so I went ahead and fixed it for myself. This is my updated one in case you want to copy it: let(daysBetween, dateBetween(prop("Do Date"), today(), "days"), ifs( prop("Status") == "Done", "🎉 Completed".style("green"), daysBetween < 0, format("‼ " + if(abs(daysBetween) == 1, "1 Day Overdue", abs(daysBetween) + " Days Overdue")).style("red"), daysBetween == 0, "⚠ Due Today".style("yellow"), daysBetween > 0, format("⏰ " + if(daysBetween == 1, "1 Day to Go", daysBetween + " Days to Go")).style("blue"), "⏳ Set Schedule".style("orange") ) ).style("b") Note that I use "Do Date" instead of "Due Date," color-coded it, added emojis, and replaced the checkbox property with a status one so adjust it accordingly!

[@Regularrylie]

omg tysmmmm

[@Bella-tp6ld]

THANK YOU SO MUCH !!!

[@Liapalma]

Muchas gracias!! seguía con la duda

[@trix7579]

tried this but it wouldnt let me copy it in and when i typed it things kept on disappearing

[@jeepers.creeker]

@@trix7579 I changed some of the properties. Have you made sure the properties are correct? For example, prop("Status") == "Done" works for me because I renamed one of the options "Done" in the status property. So if you have yours named "Completed" for example, you'd need to rename it in the formula with prop("Status") == "Completed" or if you just have a checkbox, prop("Name of checkbox") == true (if checked) and false (if unchecked). Make sure the date property's name is the same in the formula as well. The properties in the formula should be highlighted and there's no need for the prop("___") anymore. Just ensure that the name you set for your properties is the same as the one you put in the formula!

[@Alaa-Benachour]

Thank you so much! However, what if I want the countdown to calculate the days between two specific dates? I don’t want it to start from today but rather from a chosen start date to a set end date. I tried using the “end date” option, but the countdown doesn’t seem to function as expected.

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

[@anickglobensky-bromow9820]

Simple and easy to follow!

[@creative_cove]

thank you!

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

[@o_wrzosowa]

Girl, you helped me a lot! Love ya ❤

[@creative_cove]

You're so welcome! 😊

[@la-vie-est-simple]

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

[@creative_cove]

Thanks, will do!

[@headstrong1810]

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

[@kescazuos4408]

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

[@p0_llen]

hello! i just have a problem: when i did the code line "datesBetween == 0", the 0 keeps showing, and idk what to do can someone have a solution please?

[@jackqaq238]

Thank you !! very helpful

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

[@RodGomez1]

Thank you. This was super helpful.

[@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!"

[@Waterslide_Productions]

The video helped me quit a bit, thankyou 🙏

[@dwikdune5212]

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

[@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! 💗

[@chris.helders]

Thank you for such a clear explanation! I have a question. Is there a way to type more than one number in a row in one line of a formula? I want to display the phrase in my language and it has different cases therefore the endings of the word "day" translated into my language are quite different for different bunches of numbers. So, is there a way to put every number I need in one line of a formula without writing each number with different lines? The example: 2, 3, 4, 22, 23, 24 and so on - would have the same ending in the word "day", but 5, 6, 7, 25, 26, 27 and so on - would have different from the first row but the same in this kind of numbers. Tell me there's a way, pleeeease, I reeeeeeeeally don't wan't to have that many lines of code :D

[@putrisidestory]

Thank you so much girl

[@creative_cove]

You are so welcome!

[@rumman553]

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?

[@alyssaa1524]

Hi! I have an issue with my formula. Why does mine say "daysBetween is not defined" when I am copying the formula for the if statements??

[@creative_cove]

You need to tell the formula what 'daysBetween' stands for. In the formula, we used the lets() function to define daysBetween so we could reference it later. Make sure you've copied that part of the formula to same as mine to ensure it works properly 😊

[@alyssaa1524]

@@creative_cove I have another question if that is okay. Will the formula automatically change from "days left" to "Due today" once it is on the due date?

[@creative_cove]

@@alyssaa1524 yes it will! 😊

[@selmachristensen9883]

Mine keep saying «set due date» even though i already have set it, what can i do to fix it?

[@Haezy17]

Thanks a lot ❤

[@creative_cove]

You're welcome 😊

[@Spider2B]

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

[@creative_cove]

I'm glad you found it useful! Thanks for the sub :)

[@esc.0788]

hi! is there a way to change the font by code?

[@creative_cove]

You can't change the font unfortunately. You can use the "c" to add code styling as I did in the video or if you omit the "c", it will display as normal text instead which looks slightly different. 😊

[@harold.machado]

Thank you.

[@creative_cove]

You're welcome! Thanks for watching :)

[@ingriderthalmartinez8671]

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

[@dwifebrianto9738]

I'm curious about this too

[@andres-wx9sg]

what do i do if the "mark as complete" won't show up for me to add into my formula?

[@creative_cove]

You need to add the ''mark as complete" checkbox before doing the formula. So just add a new checkbox property and name it 'mark as complete'

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

[@مُحَّمَد-ش3ع9ز]

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 😊

[@onovoesdras]

by the way, a great video!

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

[@ramonablasius9748]

Thank You

[@creative_cove]

You're welcome! 😊

[@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’ 😊

[@FirdausTarmizi-p3p]

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

[@FirdausTarmizi-p3p]

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.

[@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 ! ☺️

[@AliyahJanzen]

Computers don’t let you enter in these, can’t follow this :(

[@creative_cove]

It should work on both the Notion web version and the app. I built the formula on a computer so it does work 😊

[@ALPuneeth]

🎈