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 :)
@celinekruger97108 ай бұрын
thank you so much :D
@samuelponce2200 Жыл бұрын
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!
@oneforallah Жыл бұрын
SAME AF
@Birandoo Жыл бұрын
FOR 24-HOUR CLOCK PEOPLE: If you want to use 24 hour time instead of am/pm, just change "hh:mm" to "HH:mm"
@timotejtomicek4538 Жыл бұрын
You save my life. Thanks Bro ❤
@mdshahed6758 Жыл бұрын
Thank you. I use 24 hour clock.
@danielabreu66986 ай бұрын
and turn; if (formatDate(prop("Date"), "LT") == "12:00 AM", into -- > if (formatDate(prop("Date"), "LT") == "12:00" deleting AM
@user_-qg6yd6 ай бұрын
@@danielabreu6698 Thank you!! Your comment solved my problem, cheers
@pvanharmelen Жыл бұрын
Bar none, you explain Notion way better than anyone else out there. You have a real gift for this, Sarah. Thank you!
@kitchensarehot87699 ай бұрын
This calendar is insane, genuinely twice as better than most on youtube. Great work
@ShayaanAzeem Жыл бұрын
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"), " ✓", "")
@lorenzorecuero5611 Жыл бұрын
Thanks!!!!
@Niko-ju2gi Жыл бұрын
Thank u a lot!
@theebelovedfavorlyn Жыл бұрын
You are amazing thank you so much! God bless you
@koeminio Жыл бұрын
it doesnt work for me pfff
@theebelovedfavorlyn Жыл бұрын
@koeminio it does, just remove any extra spaces
@stefanlaslov1180 Жыл бұрын
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"), " ✓", "")
@_sahna_sh_ Жыл бұрын
It doesn’t work 😢
@koeminio Жыл бұрын
it works bro youre top, thanks
@Savallion Жыл бұрын
I'm so glad you covered the most important feature first: making the weeks start on Monday 😂
@TheSoapThatCan6 ай бұрын
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.
@seventeendegree Жыл бұрын
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.
@user30278 күн бұрын
There is a great project management template for that kind of stuff, including sprints, projects, tasks, etc. Great for a team
@ghazalsahebzamani4925 Жыл бұрын
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!
@believe701 Жыл бұрын
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!!
@deborapassosjt Жыл бұрын
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 🇧🇷
@theencryptedpartition4633 Жыл бұрын
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
@edgarmalone7694 Жыл бұрын
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.
@SalimMalibari_Comments Жыл бұрын
Im waiting for that ...
@brendalg4 Жыл бұрын
They would need more than that to kill Obsidian. Such as local files.
@justnaturalcake1 Жыл бұрын
I mean there are websites like Notion2charts who already allow for graphs
@theencryptedpartition4633 Жыл бұрын
@@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
@justinemutch86726 ай бұрын
Thank you, you have explained this clearly... and slowly enough for me to understand as I'm new to Notion
@InTheLifeOfTanmai9 ай бұрын
I think this is so far the best week planner I ever create, Thank you so much for this
@antonioccortes Жыл бұрын
well finally this day has come, this is great!!! thank you again for all the incredible content, red.
@RedGregory Жыл бұрын
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
@kriskelvin1814 Жыл бұрын
"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."
@saschagottlieb9735 Жыл бұрын
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....
@Unknown2634g Жыл бұрын
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?
@ApocalypseBB Жыл бұрын
@@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 ;_;
@RockXann1408 Жыл бұрын
@@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"), " ✓", "")
@SalimMalibari_Comments Жыл бұрын
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
@magilu11 Жыл бұрын
I love your brain. THANK YOU for giving us so much information, it has made a real difference in my everyday life.
@rachelcackleberry Жыл бұрын
So happy when I saw this. I have been HANGING OUT for this update!
@zoefisk Жыл бұрын
YES!!!!!! BEEN WAITING FOR THIS!!!
@Aendus17 ай бұрын
super template, i have been searching for such a template for months. great work
@EricVasquezDesign Жыл бұрын
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!
@VioletGreen-v5s Жыл бұрын
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!
@rdp6096 Жыл бұрын
THANK YOU!! I just started using Notion but this is exactly what I needed for work. I forget wayyyyy too much lol. Appreciate you!
@derechtepotti9783 Жыл бұрын
best notion video on yt! Thank you very much! As a beginner it helped me a lot. Keep up the Great work :)
@karhadee3660 Жыл бұрын
thankyou somuch red for this amazing and helpfull video, it means a lot
@AislinEvans Жыл бұрын
you have such a knack for teaching from the ground up, pal. appreciate you!!
@keylimegween Жыл бұрын
Thank you for being so generous with your notion knowledge!
@jamemadison6499 Жыл бұрын
FINALLY, just used trello for my task management for a brief moment. now kinda wanna go back to notion with this new feature
@consciouschokri Жыл бұрын
Thank you for sharing this template and video. It's an absolute game-changer!
@jfpdc888 Жыл бұрын
So Good!!! Great overall instruction! Thank you for creating this vid and All The Best To YOU!
@sena7876 Жыл бұрын
THE BEST NOTION TUTORIAL EVER!!
@silviamancini91 Жыл бұрын
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
@BryanChowKing Жыл бұрын
same here
@Mark4Jesus Жыл бұрын
That calendar looks really sweet!
@monkeydluffy3529 Жыл бұрын
This is so cool. Your explanation is to the point. Thank you 1000 times !!!!!
@SelfImprovement560 Жыл бұрын
Red Gregogy the best of best!
@camo8723 Жыл бұрын
Amazing tutorial! Notion is sorting my life right now 🙌🏼
@naptitude25 Жыл бұрын
Thank you thank you thank you. I've been looking for it for the past two days
@adelaidewalker560 Жыл бұрын
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!
@TheAccumulation Жыл бұрын
did you find a way to get repeating tasks?
@niik99 Жыл бұрын
Finally, I'm officially saying goodbye to my database with tags of the week, thanks!
@RunYourLuck Жыл бұрын
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.
@SalimMalibari_Comments Жыл бұрын
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
@RunYourLuck Жыл бұрын
@@SalimMalibari_Comments for the habit, do you have are your properties the days of the week? And then your tasks are just check lists?
@TulliaDean Жыл бұрын
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! :)
@paulaarias2229 Жыл бұрын
Thank you so much for this!!! I'm learning how to use notion and this weekly planner is exactly what I was looking for ❤
@rjvidalt1 Жыл бұрын
Excellent video ... as always . Red rocks. Thank you
@armandogutierrez2880 Жыл бұрын
Very nice and fast ideas for all, thanks for sharing. Your videos are greats and helpful.
@mikainamahoro2556 Жыл бұрын
Your videos are very very good. Thank you for all the hard work you put in.
@softwareengineer8923 Жыл бұрын
Your video helped me a lot,thanks!
@malikastar9265 Жыл бұрын
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 !
@Mohamed.wael710 ай бұрын
That was the smoothest explanation!
@SunilL-m7q Жыл бұрын
Thank you for this informative tutorial ! This is helping me to organize my time better.
@kavitatambe2909 Жыл бұрын
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!
@JoyKabeni Жыл бұрын
I like how you explain your notion task, easy to understand 🎉
@devarni Жыл бұрын
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!
@robertmaxey5406 Жыл бұрын
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,
@danielprugger Жыл бұрын
Thank you so much Red! You're amazing!! 👍
@carolkawasaki-clykstudio873 Жыл бұрын
FINALLY! This took ages and was so obviousn
@angave Жыл бұрын
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?
@cincosolas_ Жыл бұрын
Love this weekly planner! Is there anyway to set up a re-occuring task using this method? thank you!
@d_dharawat Жыл бұрын
Finally On the point content :)
@alberto4166 Жыл бұрын
UOOOUUU IM SOOO GRATEFUL, YOU HELP A LOT BABY!!! THANKSS!
@saraiitrecruiter7993 Жыл бұрын
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
@Alexis-qz1pf Жыл бұрын
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.
@mohamedshali394 Жыл бұрын
thank you so much for the great explanation and given the info in such a wonderfully simple way. Many thanks.
@ni7__13 Жыл бұрын
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 :)
@projetosdabru Жыл бұрын
Thanks again, Red!
@PaulinaGallegos412 Жыл бұрын
This is exactly what I was looking for! Thank you for being so clear, concise and helpful! Great video ☺🤗
@farouk6437 Жыл бұрын
I love it, so simple and minimalistic, thank you!
@roshanakgolesorkhi2806 Жыл бұрын
Amazing 👌 This is what I exactly needed, Thanks!
@theebelovedfavorlyn Жыл бұрын
You are amazing thank you so much for this amazing video!!!!
@StaceyJLipowski Жыл бұрын
This is exactly what I needed!! Thank you :)
@Creamy_Bunnylive Жыл бұрын
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
@Fonsecamvp Жыл бұрын
Thank you, practice and usable.
@gersonhernandez9107 Жыл бұрын
The video is very comprehensive 👏
@HitenderThejaswi Жыл бұрын
Thank you so much for this wonderful video tutorial ! :)
@nithinaraveti8571 Жыл бұрын
Really helpful, Thanks for the vid💙
@tea.garden Жыл бұрын
Love you red ❤️
@liveforodtu Жыл бұрын
not a big feature but still you can copy this if(formatDate(prop("Date"), "LT") == "12:00 AM", "Any Time", formatDate(prop("Date"), "h:mma").upper() + " - " + formatDate(dateEnd(prop("Date")), "h:mma").upper()) + if(prop("Completed"), " ✓", " ✘")
@koeminio Жыл бұрын
your code really works but at the end appears an "X"
@cristianemoraz743811 күн бұрын
I Love your tutorials
@Scarlattittude Жыл бұрын
🥰 Thanks you SO MUUUUUCH Red ... do you know I adopted Notion mostly because of YOU and your amazing demos/tutos/GIFTS ?
@marinazuniga2418 Жыл бұрын
I copied the formula and pasted it on my calendar, but it won't work. It says Notion says: "end is not defined. [61,64] The function "end()" was renamed to "dateEnd()". [61,64] end is not defined. [171,174]"?
@jxpt8935 Жыл бұрын
I think notion changed their formula language
@TheSoapThatCan6 ай бұрын
@@jxpt8935 If you're still curious or need help, this formula should work. I changed it and also switched to 24 hour clock cause AM/PM drives me up a wall. if(formatDate(prop("Date"), "LT") == "12:00 AM", "Any Time", formatDate(prop("Date"), "HH:mm") + "-" + formatDate(dateEnd(prop("Date")), "HH:mm")) That's without the checkmark. If you want the checkmark then use this one (found a nice green one so it's nice and visible in both dark and light theme): if(formatDate(prop("Date"), "LT") == "12:00 AM", "Any Time", formatDate(prop("Date"), "HH:mm") + "-" + formatDate(dateEnd(prop("Date")), "HH:mm")) + if(prop("Completed"), " ✅", "")
@georgekimani4888 ай бұрын
This is what I needed. I'm having a bit of a challenge since Notion Calendar has been added now Notion Calendar, and now it's not synced with the things I do with my calendar. Ex. I could use this template and put my task, and it would also show in the Notion Calendar. But let's say I have a class on Friday which is already on the calendar but doesn't show on my template and I don't want to add it because it will just show twice. It's just not in sync.
@riccardoarmellin1625 Жыл бұрын
Thanks a lot! Keep up the good work!
@isirlasplace91 Жыл бұрын
Thanks so much for sharing this!!!
@_astrog137 Жыл бұрын
Thanks so much for sharing! This is so neat. Couldn't have figured out the formula by myself 🤣
@ya_gema Жыл бұрын
It's awesome! Thank you so much!!
@josephwilliams8412 Жыл бұрын
Great stuff, Red. Thanks.
@maximefortinmusic Жыл бұрын
Thanks Red!
@oatlylatte9 Жыл бұрын
that formula is helpful. thanks mate
@harsha5475 Жыл бұрын
Thank you, this is really helpful.
@MichaelCardenas-pc2tz Жыл бұрын
you are a legend thank you
@vsastock613 Жыл бұрын
You guide is very easy to understand, Thanks a lot
@rashid_ali Жыл бұрын
Thank you so much for sharing this calendar. I can add another property of duration and check how long a particular activity will take. I can then add all activities to see the sum of the duration of those activities. Question, if I wanted to divide the sum of those activities or basically sum of any property in a table with a different number, how can we do that? The divide property doesn't seem to work when I try to apply this formula "divide(sum(prop("Duration")), 24*31)" Basically the goal is to see what % of a given month is already booked :)
@SAKVA Жыл бұрын
Thank you so much! Great tamplate!!!
@grantnelson7717 Жыл бұрын
Love your videos!
@alanwallace3253 Жыл бұрын
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 “.
@renlucaworld Жыл бұрын
Exactly what I was looking for. Do you know how to add the hours as blank tasks? Other thing is if we could color in the tasks and leave the hours blank? you are so good at taking people through things...BRAVO!!!!
@hannahmiranda9419 Жыл бұрын
This is so useful. Thanks!
@hanasyankhara678 Жыл бұрын
Thank's! it's very helpfull👍👍
@mike35424 Жыл бұрын
Is there a way to set 'include time' as a default for a new date field database entry? I'd like to avoid having to click 'include time' each time I create an entry and specify a default.