Smart Countdown Formula In Notion - EASY Notion Formulas
Вставка
- Опубліковано 28 лип 2024
- 🧠 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
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 😊
See! That is good customer service right there. I just kept telling myself well this is a in between dates formula. but thank you for posting the fix and pinning the comment!! You are AWESOME!
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!
Glad it helped!
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.
😀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 "UA-cam Gods" (aka YT algorithm) sent you to my UA-cam feed. And for the rest of us, we need to share, share, share and share you videos. 👍🏻👍🏻👍🏻⭐⭐⭐⭐⭐
Thank you so much for your support! I really appreciate it :)
Thank you. This was super helpful.
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 :)
You're very welcome! Thanks for subscribing :)
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!!
You are so welcome! Thanks for watching 😊
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.
Girl, you helped me a lot! Love ya ❤
You're so welcome! 😊
Simple and easy to follow!
thank you!
I did it! you explain things very well. Love your content. Helps to have transcript showing to follow along.
You're welcome, thanks for watching! :)
Amazing videos ❤😍
Thanks for the great toturial, keep going..
Thanks, will do!
Thank you so much girl
You are so welcome!
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!
Please please help to do a spaced revision program based on how many questions you get right and wrong!! Pleaaase 😊
Thank you.
You're welcome! Thanks for watching :)
Thank You
You're welcome! 😊
Thanks a lot ❤
You're welcome 😊
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
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?
Thank you for this, you have earned a sub from me!
I'm glad you found it useful! Thanks for the sub :)
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!
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! :)
Aha, makes perfect sense! Thank you so much for the quick reply 😊
LOOKING FOR THIS! 🎉 THANKS!
hi this code is very helfullone question, what if the checkbox is by percentege is that posible ?
Do you also think the formula hub could be designed better inside notion? I dont find it handy. Great video though, keep it up!
Hi! I am thinking of doing a count up days with a progress bar. Any idea how do I go about it?
How do I add hours, minutes and seconds left to this formula?
Thank you so much for the content.
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?
i have the in progress completed and not started status. what would be the code/function in countdown for incomplete and completed?
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!
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.
@@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! 💗
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 :)
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.
@@creative_coveyou’re right, it works, thank you very much ! ☺️
how about when my property is status instead of checkbox?
In that case, you could just change the if statement to something like if(status == "complete"), "Completed!"
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?
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.
@@creative_cove thank you so much! you're an angel 🥹
im having trouble adding more space to the output between the days and the text
You need to manually add in a space just before the text within the quotation marks else it won't add one.
what do i do if the "mark as complete" won't show up for me to add into my formula?
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'
Why, in my notion "Mark as complete" do not appear?
It’s something I added myself. You just add a checkbox property and name it ‘Mark as complete’ 😊
I using property status..how can show complete!?
Can you show me complete formula
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.
🎈
I have a problem, when due date is tomorrow
the formula shows Due Today!
How can i fix that
Sorry it was a small bug in the formula. Please replace the now() function with today() instead and it will work 😊