If anyone is still having trouble with the formula either by receiving the "checkbox is not defined" or seeing the formula space say anything except "Any Time" try this: if(formatDate(prop("Date"), "LT") == "12:00 AM", "Any Time", formatDate(prop("Date"), "h") + "-" + formatDate(dateEnd(prop("Date")), "h:mma")) + if(prop("Completed"), " ✓", "") Wherever you see the property "Date" and "Completed" make sure they appear in the grey boxes :)
Hey guys, in the video, the formula is quite minimal (showing only the hour of the start time) because the calendar view does show the exact start time. I changed it to show the full start time so it can be easier to read in all database view types. It's updated in the template, and here it is as well (start time format is changed from "h" to "h:mma"): if(formatDate(prop("Date"), "LT") == "12:00 AM", "Any Time", formatDate(prop("Date"), "h:mma") + "-" + formatDate(end(prop("Date")), "h:mma")) + if(prop("Completed"), " ✓", "") You can play around with these formats any way you'd like. Here are more examples: "LT" for 3:30 PM "H:mm" for 15:30 "h:mma" for 3:30pm "h:mmA" for 3:30PM
"Your content is amazing Red! I love your videos and I gain so much knowledge from them. Thank you so much for that. I was wondering if you happen to know how to write a Notion formula for calculating the factorial of a given number? I've been struggling with it for a while now without any success."
Hey I have a problem with that formula though. When I have an Action with a Date property that consists just of an start date but has no end date, I get this for example: 15:46 - 15:46. I tried working around it but I don't seem to get a solution....
Hi Is there a way to turn them into recurring tasks? I added a small change where in I have start date, end date and start time and end times to my tasks as well. The problem is the formula would populate my calendar only on the day the template was set to instead of the recurring date. How do I make this possible?
@@saschagottlieb9735 I wanted to have a solution for that issue as well but I can't figure it out yet! I hope someone can find a solution and share it ;_;
@@saschagottlieb9735 Hi ! I just managed to found a way! You have to say something: if the end time is the same as the start time, then only show the star time. Here's the formula I used: if(formatDate(prop("Date"), "LT") == "00:00", "Any Time", if(formatDate(end(prop("Date")), "h:mma") == formatDate(prop("Date"), "h:mma"), formatDate(prop("Date"), "h:mma"), formatDate(prop("Date"), "h:mma") + "-" + formatDate(end(prop("Date")), "h:mma"))) + if(prop("Completed"), " ✓", "")
this is absolutely amazing, i literally have been waiting for something like this since i started using notion, thanks for all the good content you create and share with all of us!
For everyone having trouble with the given formula here is the fixed version: if(formatDate(prop("Date"), "LT") == "12:00 AM", "Any Time", formatDate(prop("Date"), "h:mma") + "-" + formatDate(dateEnd(prop("Date")), "h:mma")) + if(prop("Checkbox"), " ✓", "")
Loved that you actually showed the whole thing from start and not just told people to download a template and follow from that point. You got yourself a fan.
There was a new update in notion and the formula shown in the video doesn't work anymore, here is the updated one: if( formatDate(prop("Date"), "LT") == "12:00 AM", "Any Time", formatDate(prop("Date"), "h:mma") + "-" + formatDate(dateEnd(prop("Date")), "h:mma") ) + if(prop("Completed"), " ✓", "")
Notion is really powerful. I'm considering it to use at work, for managing the entire production. A custom calender with a database could work really great. Our tasks depend on working days or calendar days, so a database seems necessary. I could link that with a dashboard and would always see directly, which department has which tasks to finish today. This could also be used for personal management or planning the vacations of a team.
@@edgarmalone7694 but what if you like both apps and then you have to copy your whole notebook to obsidian. Idk if there was faster way but I spent like 1-2 hours to view my economics notes from Notion in Obsidian graph view
I would like to recommend adding a templete button that create habits then drag and drop... this will fix all the issues that everyone face from the recurring templete
you are a genius and also wonderful teacher!!! I want to make elaborated plant watering schedule and this is very inspiring. I have no idea yet how to make what I have in mind but now I know about formulas!
Wow! This video did a really great job of explaining the new feature. I have been looking for a way to plan out my week by dedicating certain days to scripting, filming, and editing my videos, and as a visual person this is super helpful. Thank you so much for the walkthrough!
Hi Red very well explained. I can't figure it out the formula...in my case it's not working. maybe something change in the formula expression since last time? thank you
Thank you so so much for this video! I've been stuck on how to create a combined Daily/Weekly planner for ages and this is exactly what I needed! Really appreciate you sharing this video! :)
Love this! Thanks so much. I’ve been trying to get into Notion for a while now, but always feel so overwhelmed. As a sole trader, I’m realising more and more how badly I need something for task and project management. Will be using this as part of the “office” I’m trying to build for myself. Now just need to work out if I can code the calendar to have repeating tasks!
your videos always help me get going in Notion! I appreciate all the freebies and content you create 🙏 I’d love to understand formulas more, do you have any tips on how to learn or what language would be good to learn more about?
This can be quite useful, Red. Notion seems to add new stuff weekly. Just this AM, there was an update. Currently, I do not use Notion because I cannot access it offline. I use Obsidian. I still keep up with the Notion community, however. I also test new discoveries as I find them. Great job, Red,
hey red thank you so much for this! i was looking for a weekly calendar task planner for such a long time! this was really helpful and informative. really appreciate it :)
I'd love to see this, but recurring weekly spread. I followed your habits list but my habits change day to day. Like for workouts, household chores, or even a way to add Adhoc tasks.
What im doing right now... i have buttons for habits then schedule them at the begining of the week because my habit changes week by week so chorse sometime become saturday sometime friday... try it you will solve alot of your issues ... you just need a weekly review to recreate them
Thank you so much for this video. I am a beginner youtuber.I am also setting up my notion. This video has been so useful for me. Very well explained. Subscribed!
Red, I remember when you didn’t have 5600 subscribers, now you have over that in views in day 1. I’m so stoked for you. I knew from the first video I saw you were going far, congratulations! QUESTION: Is there a way or formula to automatically forward tasks NOT COMPLETED ? Sadly it happens , No matter how good my “ intentions “.
Thats really helpfull, I like this very much, but have a question. Some of my tasks do not have end time, or I just dont know it. And if I dont set the end time, it appears like "3:00-3:00". But I would like it to be just "3:00". I've been trying to change formula, but it doesnt work well. I don't understand what im doing wrong, PLEASE HELP
for her time property if the time is not assigned it would be better to use contains(format(prop("Date"),":") so you don't get confused with assigning something at midnight.
I loved this new view, but I think it needs more improvements before we can use it with the calendar blocking method for example, for me, it's a pain to select a date and a time so manually 😅😅 just imagine how cool it would be to have the option to drag an appointment as you do in GCal and to select a date & time like in Todoist
You can bulk-add a random date to all appointments in the table view, by copying/dragging. Then in the calendar view you can drag the appointment to the appropriate date.
I have a tip to share with you. A great thing is to create different task template to each "type of task". For example I have the household tasks with the house icon and the work tasks with the monitor icon. :D
If anyone is still having trouble with the formula either by receiving the "checkbox is not defined" or seeing the formula space say anything except "Any Time" try this:
if(formatDate(prop("Date"), "LT") == "12:00 AM", "Any Time", formatDate(prop("Date"), "h") + "-" + formatDate(dateEnd(prop("Date")), "h:mma")) + if(prop("Completed"), " ✓", "")
Wherever you see the property "Date" and "Completed" make sure they appear in the grey boxes :)
thank you so much :D
FOR 24-HOUR CLOCK PEOPLE:
If you want to use 24 hour time instead of am/pm, just change "hh:mm" to "HH:mm"
You save my life. Thanks Bro ❤
Thank you. I use 24 hour clock.
and turn; if (formatDate(prop("Date"), "LT") == "12:00 AM", into -- > if (formatDate(prop("Date"), "LT") == "12:00" deleting AM
@@danielabreu6698 Thank you!! Your comment solved my problem, cheers
Hey guys, in the video, the formula is quite minimal (showing only the hour of the start time) because the calendar view does show the exact start time. I changed it to show the full start time so it can be easier to read in all database view types.
It's updated in the template, and here it is as well (start time format is changed from "h" to "h:mma"):
if(formatDate(prop("Date"), "LT") == "12:00 AM", "Any Time", formatDate(prop("Date"), "h:mma") + "-" + formatDate(end(prop("Date")), "h:mma")) + if(prop("Completed"), " ✓", "")
You can play around with these formats any way you'd like. Here are more examples:
"LT" for 3:30 PM
"H:mm" for 15:30
"h:mma" for 3:30pm
"h:mmA" for 3:30PM
"Your content is amazing Red! I love your videos and I gain so much knowledge from them. Thank you so much for that. I was wondering if you happen to know how to write a Notion formula for calculating the factorial of a given number? I've been struggling with it for a while now without any success."
Hey I have a problem with that formula though. When I have an Action with a Date property that consists just of an start date but has no end date, I get this for example: 15:46 - 15:46.
I tried working around it but I don't seem to get a solution....
Hi
Is there a way to turn them into recurring tasks? I added a small change where in I have start date, end date and start time and end times to my tasks as well. The problem is the formula would populate my calendar only on the day the template was set to instead of the recurring date. How do I make this possible?
@@saschagottlieb9735 I wanted to have a solution for that issue as well but I can't figure it out yet! I hope someone can find a solution and share it ;_;
@@saschagottlieb9735 Hi ! I just managed to found a way! You have to say something: if the end time is the same as the start time, then only show the star time. Here's the formula I used:
if(formatDate(prop("Date"), "LT") == "00:00", "Any Time", if(formatDate(end(prop("Date")), "h:mma") == formatDate(prop("Date"), "h:mma"), formatDate(prop("Date"), "h:mma"), formatDate(prop("Date"), "h:mma") + "-" + formatDate(end(prop("Date")), "h:mma"))) + if(prop("Completed"), " ✓", "")
This calendar is insane, genuinely twice as better than most on youtube. Great work
Bar none, you explain Notion way better than anyone else out there. You have a real gift for this, Sarah. Thank you!
this is absolutely amazing, i literally have been waiting for something like this since i started using notion, thanks for all the good content you create and share with all of us!
SAME AF
I'm so glad you covered the most important feature first: making the weeks start on Monday 😂
For everyone having trouble with the given formula here is the fixed version: if(formatDate(prop("Date"), "LT") == "12:00 AM", "Any Time", formatDate(prop("Date"), "h:mma") + "-" + formatDate(dateEnd(prop("Date")), "h:mma")) + if(prop("Checkbox"), " ✓", "")
Thanks!!!!
Thank u a lot!
You are amazing thank you so much! God bless you
it doesnt work for me pfff
@koeminio it does, just remove any extra spaces
Loved that you actually showed the whole thing from start and not just told people to download a template and follow from that point. You got yourself a fan.
You saved my life!! Thank you so much. I got from 0 to 100 in notion just by seeing 2 of your videos; you explain so well!
There was a new update in notion and the formula shown in the video doesn't work anymore, here is the updated one:
if(
formatDate(prop("Date"), "LT") == "12:00 AM",
"Any Time",
formatDate(prop("Date"), "h:mma") + "-" + formatDate(dateEnd(prop("Date")), "h:mma")
) + if(prop("Completed"), " ✓", "")
It doesn’t work 😢
it works bro youre top, thanks
Omg thank you so much!!!I was searching vídeos like this in portuguese and I didn’t found anyone!Love it ❤ thanks from Brazil 🇧🇷
Notion is really powerful. I'm considering it to use at work, for managing the entire production. A custom calender with a database could work really great. Our tasks depend on working days or calendar days, so a database seems necessary. I could link that with a dashboard and would always see directly, which department has which tasks to finish today. This could also be used for personal management or planning the vacations of a team.
This is awesome!!! Notion is finally starting to combine the best of others to their platform. If they add the graph view, they’ll kill off Obsidian
No let both the Notion team and the Obsidian community keep what they are doing. This allow us to have the best of both worlds.
Im waiting for that ...
They would need more than that to kill Obsidian. Such as local files.
I mean there are websites like Notion2charts who already allow for graphs
@@edgarmalone7694 but what if you like both apps and then you have to copy your whole notebook to obsidian. Idk if there was faster way but I spent like 1-2 hours to view my economics notes from Notion in Obsidian graph view
Thank you so much for sharing this!!! THIS is the schdule i´ve been wanting but never found out how to create one, I absolutely love it!!
I think this is so far the best week planner I ever create, Thank you so much for this
Thank you, you have explained this clearly... and slowly enough for me to understand as I'm new to Notion
well finally this day has come, this is great!!! thank you again for all the incredible content, red.
So happy when I saw this. I have been HANGING OUT for this update!
I would like to recommend adding a templete button that create habits then drag and drop... this will fix all the issues that everyone face from the recurring templete
I love your brain. THANK YOU for giving us so much information, it has made a real difference in my everyday life.
THE BEST NOTION TUTORIAL EVER!!
FINALLY, just used trello for my task management for a brief moment. now kinda wanna go back to notion with this new feature
you are a genius and also wonderful teacher!!! I want to make elaborated plant watering schedule and this is very inspiring. I have no idea yet how to make what I have in mind but now I know about formulas!
YES!!!!!! BEEN WAITING FOR THIS!!!
THANK YOU!! I just started using Notion but this is exactly what I needed for work. I forget wayyyyy too much lol. Appreciate you!
best notion video on yt! Thank you very much! As a beginner it helped me a lot. Keep up the Great work :)
super template, i have been searching for such a template for months. great work
Thank you for sharing this template and video. It's an absolute game-changer!
Finally, I'm officially saying goodbye to my database with tags of the week, thanks!
Thanks! Simple and direct were I looking for.
Thank you for being so generous with your notion knowledge!
thankyou somuch red for this amazing and helpfull video, it means a lot
So Good!!! Great overall instruction! Thank you for creating this vid and All The Best To YOU!
Wow, somehow the new calendar view got lost on me. Very good example and also the use of the formula is briliant... many thanks Sarah!
Wow! This video did a really great job of explaining the new feature. I have been looking for a way to plan out my week by dedicating certain days to scripting, filming, and editing my videos, and as a visual person this is super helpful. Thank you so much for the walkthrough!
Hi Red very well explained. I can't figure it out the formula...in my case it's not working. maybe something change in the formula expression since last time? thank you
same here
That calendar looks really sweet!
Your videos are very very good. Thank you for all the hard work you put in.
That was the smoothest explanation!
Thank you so much! Great tamplate!!!
Thank you thank you thank you. I've been looking for it for the past two days
This is so cool. Your explanation is to the point. Thank you 1000 times !!!!!
Red Gregogy the best of best!
Thank you so so much for this video! I've been stuck on how to create a combined Daily/Weekly planner for ages and this is exactly what I needed! Really appreciate you sharing this video! :)
Thank you so much for this!!! I'm learning how to use notion and this weekly planner is exactly what I was looking for ❤
Amazing tutorial! Notion is sorting my life right now 🙌🏼
Thank you Red, you have a great way to explain things even for someone who never used notion before, I subscribed just from watching this tutorial !
you have such a knack for teaching from the ground up, pal. appreciate you!!
Excellent video ... as always . Red rocks. Thank you
Thank you for this informative tutorial ! This is helping me to organize my time better.
Your video helped me a lot,thanks!
Very nice and fast ideas for all, thanks for sharing. Your videos are greats and helpful.
Love this! Thanks so much. I’ve been trying to get into Notion for a while now, but always feel so overwhelmed. As a sole trader, I’m realising more and more how badly I need something for task and project management. Will be using this as part of the “office” I’m trying to build for myself. Now just need to work out if I can code the calendar to have repeating tasks!
did you find a way to get repeating tasks?
Thanks again, Red!
Thank you so much Red! You're amazing!! 👍
FINALLY! This took ages and was so obviousn
I like how you explain your notion task, easy to understand 🎉
your videos always help me get going in Notion! I appreciate all the freebies and content you create 🙏 I’d love to understand formulas more, do you have any tips on how to learn or what language would be good to learn more about?
This can be quite useful, Red. Notion seems to add new stuff weekly. Just this AM, there was an update. Currently, I do not use Notion because I cannot access it offline. I use Obsidian.
I still keep up with the Notion community, however. I also test new discoveries as I find them.
Great job, Red,
thank you for this!!! 🤩
thank you so much for the great explanation and given the info in such a wonderfully simple way. Many thanks.
UOOOUUU IM SOOO GRATEFUL, YOU HELP A LOT BABY!!! THANKSS!
I love it, so simple and minimalistic, thank you!
hey red thank you so much for this! i was looking for a weekly calendar task planner for such a long time! this was really helpful and informative. really appreciate it :)
I'd love to see this, but recurring weekly spread. I followed your habits list but my habits change day to day. Like for workouts, household chores, or even a way to add Adhoc tasks.
What im doing right now... i have buttons for habits then schedule them at the begining of the week because my habit changes week by week so chorse sometime become saturday sometime friday... try it you will solve alot of your issues ... you just need a weekly review to recreate them
@@SalimMalibari_Comments for the habit, do you have are your properties the days of the week? And then your tasks are just check lists?
Finally
On the point content :)
Thank you so much for this video. I am a beginner youtuber.I am also setting up my notion. This video has been so useful for me. Very well explained. Subscribed!
Thanks Red!
Red, I remember when you didn’t have 5600 subscribers, now you have over that in views in day 1. I’m so stoked for you. I knew from the first video I saw you were going far, congratulations!
QUESTION: Is there a way or formula to automatically forward tasks NOT COMPLETED ? Sadly it happens , No matter how good my “ intentions “.
Thank you, practice and usable.
Thats really helpfull, I like this very much, but have a question. Some of my tasks do not have end time, or I just dont know it. And if I dont set the end time, it appears like "3:00-3:00". But I would like it to be just "3:00". I've been trying to change formula, but it doesnt work well. I don't understand what im doing wrong, PLEASE HELP
I dont know, i've been trying for 4-5 hours to think up, nothing works, I give up
If smb can do this let me know🙏
for her time property if the time is not assigned it would be better to use contains(format(prop("Date"),":") so you don't get confused with assigning something at midnight.
you are a legend thank you
Amazing 👌 This is what I exactly needed, Thanks!
Thanks for this video.
The video is very comprehensive 👏
Love you red ❤️
Thank you from India ❤
Love this weekly planner! Is there anyway to set up a re-occuring task using this method? thank you!
I Love your tutorials
I loved this new view, but I think it needs more improvements before we can use it with the calendar blocking method for example, for me, it's a pain to select a date and a time so manually 😅😅 just imagine how cool it would be to have the option to drag an appointment as you do in GCal and to select a date & time like in Todoist
You can bulk-add a random date to all appointments in the table view, by copying/dragging. Then in the calendar view you can drag the appointment to the appropriate date.
SAME FOR THIS GREG !
Great stuff, Red. Thanks.
You are amazing thank you so much for this amazing video!!!!
Thanks a lot! Keep up the good work!
It's awesome! Thank you so much!!
I have a tip to share with you.
A great thing is to create different task template to each "type of task". For example I have the household tasks with the house icon and the work tasks with the monitor icon. :D
Really helpful, Thanks for the vid💙
that formula is helpful. thanks mate
Thanks so much for sharing this!!!
This is exactly what I needed!! Thank you :)
Love your videos!
Hi!I'm in Brazil!thank Very much!
Thank you so much for this wonderful video tutorial ! :)
You guide is very easy to understand, Thanks a lot
This is exactly what I was looking for! Thank you for being so clear, concise and helpful! Great video ☺🤗
Pretty cool. Thank you!
This is so useful. Thanks!
i love your channel