New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)

[@J_U_L_E_S_246]

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

[@celinekruger9710]

thank you so much :D

[@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"), " ✓", "")

[@pvanharmelen]

Bar none, you explain Notion way better than anyone else out there. You have a real gift for this, Sarah. Thank you!

[@kitchensarehot8769]

This calendar is insane, genuinely twice as better than most on youtube. Great work

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

[@TheSoapThatCan]

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.

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

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

[@danielabreu6698]

and turn; if (formatDate(prop("Date"), "LT") == "12:00 AM", into -- > if (formatDate(prop("Date"), "LT") == "12:00" deleting AM

[@user_-qg6yd]

@@danielabreu6698 Thank you!! Your comment solved my problem, cheers

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

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

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

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

[@InTheLifeOfTanmai]

I think this is so far the best week planner I ever create, Thank you so much for this

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

[@justinemutch8672]

Thank you, you have explained this clearly... and slowly enough for me to understand as I'm new to Notion

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

[@antonioccortes]

well finally this day has come, this is great!!! thank you again for all the incredible content, red.

[@jamemadison6499]

FINALLY, just used trello for my task management for a brief moment. now kinda wanna go back to notion with this new feature

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

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

[@SAKVA]

Thank you so much! Great tamplate!!!

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

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

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

[@Aendus1]

super template, i have been searching for such a template for months. great work

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

[@karhadee3660]

thankyou somuch red for this amazing and helpfull video, it means a lot

[@sena7876]

THE BEST NOTION TUTORIAL EVER!!

[@derechtepotti9783]

best notion video on yt! Thank you very much! As a beginner it helped me a lot. Keep up the Great work :)

[@Mark4Jesus]

That calendar looks really sweet!

[@keylimegween]

Thank you for being so generous with your notion knowledge!

[@AislinEvans]

you have such a knack for teaching from the ground up, pal. appreciate you!!

[@consciouschokri]

Thank you for sharing this template and video. It's an absolute game-changer!

[@zoefisk]

YES!!!!!! BEEN WAITING FOR THIS!!!

[@jfpdc888]

So Good!!! Great overall instruction! Thank you for creating this vid and All The Best To YOU!

[@mikainamahoro2556]

Your videos are very very good. Thank you for all the hard work you put in.

[@caosespaz]

Thanks! Simple and direct were I looking for.

[@viktrb]

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

[@viktrb]

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🙏

[@DannyArchive]

How do i make the Formula date at 6:20 into 24 time format insteed of 12 hour format edit: fixed it if(formatDate(prop("Date"), "LT") == "00:00", "Any Time", formatDate(prop("Date"), "HH:mm") + "-" + formatDate(end(prop("Date")), "HH:mm")) + if(prop("Completed"), " ✓", "")

[@gianpaololapomarda]

Big W for you

[@naptitude25]

Thank you thank you thank you. I've been looking for it for the past two days

[@monkeydluffy3529]

This is so cool. Your explanation is to the point. Thank you 1000 times !!!!!

[@Mohamed.wael7]

That was the smoothest explanation!

[@SelfImprovement560]

Red Gregogy the best of best!

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

[@armandogutierrez2880]

Very nice and fast ideas for all, thanks for sharing. Your videos are greats and helpful.

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

[@camo8723]

Amazing tutorial! Notion is sorting my life right now 🙌🏼

[@rjvidalt1]

Excellent video ... as always . Red rocks. Thank you

[@SunilL-m7q]

Thank you for this informative tutorial ! This is helping me to organize my time better.

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

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

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

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

[@danielprugger]

Thank you so much Red! You're amazing!! 👍

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

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

[@TheSoapThatCan]

​@@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"), " ✅", "")

[@JoyKabeni]

I like how you explain your notion task, easy to understand 🎉

[@pablocampos8872]

I would love to use it, but it doesnt work. I copy this formula: if(formatDate(prop("Date"), "LT") == "12:00 AM", "Any Time", formatDate(prop("Date"), "h:mma") + "-" + formatDate(end(prop("Date")), "h:mma")) + if(prop("Completed"), " ✓", "") And it tells me: „Date“ ist nicht definiert. [14,18] „Date“ ist nicht definiert. [64,68] „end“ ist nicht definiert. [98,101] NICHT DEFINIERT means not defined in german... I hopa you can help me with this, I would love to learn to use Notion from you! Thanks and greetings from Germany!

[@BillieAnn_]

Sad that the formula is broken with new updates and it will no longer let me duplicate the template and Im not smart enough to attempt to fix it :(

[@projetosdabru]

Thanks again, Red!

[@niik99]

Finally, I'm officially saying goodbye to my database with tags of the week, thanks!

[@mohamedshali394]

thank you so much for the great explanation and given the info in such a wonderfully simple way. Many thanks.

[@cincosolas_]

Love this weekly planner! Is there anyway to set up a re-occuring task using this method? thank you!

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

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

[@farouk6437]

I love it, so simple and minimalistic, thank you!

[@carolkawasaki-clykstudio873]

FINALLY! This took ages and was so obviousn

[@Rapha_Carpio]

I’m trying to create a calendar that manage the medicines several patients need to take, sometimes it’s weekly or every two weeks or for 5 days and I want to have the ability to add patients or modify the medicines they are already taking it

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

[@d_dharawat]

Finally On the point content :)

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

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

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

[@gwiazdapolarna_]

i have a problem, it doesnt say "any time" if a task doesnt have a time assigned, it shows 0:00-0:00. What should i do? And what does this "LT" even mean and do?

[@georgekimani488]

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.

[@Fonsecamvp]

Thank you, practice and usable.

[@alberto4166]

UOOOUUU IM SOOO GRATEFUL, YOU HELP A LOT BABY!!! THANKSS!

[@louisyurman]

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.

[@roshanakgolesorkhi2806]

Amazing 👌 This is what I exactly needed, Thanks!

[@cristianemoraz7438]

I Love your tutorials

[@gersonhernandez9107]

The video is very comprehensive 👏

[@ghie5378]

thank you for this!!! 🤩

[@riccardoarmellin1625]

Thanks a lot! Keep up the good work!

[@HitenderThejaswi]

Thank you so much for this wonderful video tutorial ! :)

[@theebelovedfavorlyn]

You are amazing thank you so much for this amazing video!!!!

[@nitishprajapati2991]

Thank you from India ❤

[@maximefortinmusic]

Thanks Red!

[@itjackz]

if(formatDate(prop("Date"), "LT") == "12:00 AM", "Any Time", formatDate(prop("Date"), "h:mma") + "-" + formatDate(end(prop("Date")), "h:mma")) + if(prop("Completed"), " ✓", "") This one , if my task have no end time only starting time, then it will show the starting time also as the end time. how to tweak it to make it only show starting time if there is no end time?

[@josephwilliams8412]

Great stuff, Red. Thanks.

[@nguyenhoangminh10]

how to move the tasks up and down in 1 single day? thanks!

[@oatlylatte9]

that formula is helpful. thanks mate

[@isirlasplace91]

Thanks so much for sharing this!!!

[@StaceyJLipowski]

This is exactly what I needed!! Thank you :)

[@tea.garden]

Love you red ❤️

[@anacristinarr2]

Hi!I'm in Brazil!thank Very much!

[@kyokogyu6228]

Hi, the formula doesn't work for me. can someone help me please 9:01