I accidentally came across your video and subscribed immediately. Amazing tutorial. I'm very impressed how Notion's advanced since I started using it approx. 8 years ago.
This is really helpful. I'm trying to set my calendar up so instead of 'day of the week' it's showing me tasks due that week out of 12 week period. (so the 'Day' that you have would be 'week' for me). How would I go about changing the formula for this?
Thank you for this. A very well thought out formula! I have been using a time blocker designed from your tutorial for a related and near similar function and one thing I came to realize is that it would be really handy to see the events for that week. I do have a separate events database for exams, CATs and birthdays but I don't think notion can allow you to show properties from different databases in single calendar view. (Unless its the "home" page I hear) That's where I think Notion calendar would come in handy. I've never used though so allow me to ask if you have any opinion on it?
Yes, the separate Notion calendar app does allow you to view different databases using one view so it could be worth checking out. It's pretty easy to set up (you just have to make an account and connect your Notion).
I love this video and I love my new weekly layout I just have 1 problem I dunno how to fix ! I did mines for 7 days and when I imput the formula for Sunday it pulls the Sunday that past and not the Sunday that’s coming up because my week starts on a Monday and notion week start on a Sunday and I dunno how to tell it to pull the upcoming Sunday and not the past one?
Thank you so much for such a great tutorial! Just wondering...how could I edit the formula for the week to start on Monday, without the task list recognizing the Sunday from the week before? Also I'm not able to add tasks straight from the calendar, do you know how I could fix this? :)
You can change the settings within Notion. Click 'Settings & members' in the side bar then 'Language & region'. You can then toggle on 'start week on Monday' and it should update like mine. I've noticed there's a bit of a glitch sometimes with the calendar. Sometimes the plus symbol to add tasks doesn't show up. Usually, if you refresh the page it resets and shows up 😊
Even after changing my week to start on Monday, the list still only seems to be recognizing the Sunday prior to the current Saturday... Got the plus symbol to work on the calendar :) thank you so much! Really appreciate it
Hello dear, Hope you are well. I am facing a problem.I am a student, to make my study organised I am using this weekly planner.So, I input my study data in database before the date comes. Well, I can enter but only in the Saturday and Sunday column. I started my week from saturday . But when I try to my Monday study data and put the date in the due, it doesn't show me which day it is.thats why it doesn't show on the column too. Now I am not getting it why its happening. Hope you'll be kind enough to look at my problem and help me out. Thank you~ Your video helps me a lot❤
Your channel is so wonderful. I'm comfortable with Notion now but your ideas are always great, and you're so clear in your explanations! One question - I tried using the week formula on my own journal templates. However, I found that Sunday counts as the first day of the week (even though I have set my week start to Monday). I'm guessing this is because of the ISO week number - but is there an easy way to sort this?
Thank you! I'm glad you're enjoying the videos. Mine does start on the Monday - do you have the settings within Notion set to start your week on a Monday. You can check by clicking 'Settings & members' in the sidebar then 'Language & region'. Make sure 'Start week on Monday' is toggled on. 😊
@@creative_cove unfortunately I already have that setting on. The issue is with format date. For example 27/07/24 is shown as week 30, and 29/07/24 is week 31, but 28/07/24 (the Sunday) is showing as week 31, whereas I want it to say 30.
@@RainyorSunnyEnding made a new formula property and this is the code i used: if( formatDate(prop("Due"), "W") == formatDate(dateSubtract(today(), 7, "days"), "W"), formatDate(prop("Due"), "ddd"), "" )
@@creative_cove found a problem with my code it freaks out on Sundays but here is the code. For formula property for Monday through Saturday: if( if( formatDate(today(), "ddd") == "Sun", formatDate(dateSubtract(prop("Due"), 1, "weeks"), "W"), formatDate(prop("Due"), "W") ) == formatDate(today(), "W"), formatDate(prop("Due"), "ddd"), "" ) For formula property for Sunday: if( if( formatDate(today(), "ddd") == "Sun", formatDate(prop("Due"), "W"), formatDate(dateSubtract(prop("Due"), 1, "W"), "W") ) == formatDate(today(), "W"), formatDate(prop("Due"), "ddd"), "" ) There might be a way to make both formulas properties into one but for now this is working for me so far
@@louiseh7302 it just stands for ‘property’. Notion adds it in when you copy and paste to indicate that something is a property. In this case it was the ‘Due’ property 😊
I've noticed there's sometimes a bug with the calendar and the plus symbol to add tasks doesn't always show up. Usually, if you refresh the page it should reset and allow you to add the tasks 😊
I have seen where others are having trouble with the formula. I tried what you did in the video and I tried what you copied and pasted in the comments. Neither are populating anything in the database. Any suggestions for modifications?
You can copy & paste the following: if(and(formatDate(prop("Due"), "W") == formatDate(today(), "W"), formatDate(prop("Due"), "Y") == formatDate(today(), "Y")), formatDate(prop("Due"), "ddd"),"") It may not have worked if your properties are named differently. E.g. 'prop' in the formula stands for property and the "Due" is the name of the property. You may need to delete 'prop("Due")' from the formula and manually select your own Due date property for it to work. 😊
They should appear on the calendar as long as you have set up the calendar as a linked view database (and not just a brand new database) and you have the date property filled out for each task 😊
Try copy and pasting the formula: if( and( formatDate(prop("Due"), "W") == formatDate(today(), "W"), formatDate(prop("Due"), "Y") == formatDate(today(), "Y")), formatDate(prop("Due"), "ddd"), "" ) You just need to ensure the date property is labeled the same as mine as 'Due'. 😊
It should work, try copy and pasting the formula directly: if( and( formatDate(prop("Due"), "W") == formatDate(today(), "W"), formatDate(prop("Due"), "Y") == formatDate(today(), "Y")), formatDate(prop("Due"), "ddd"), "" ) Just make sure that the date property has the same name as mine 'Due'.
@@creative_cove This formula returns the day of the week on which the "Due" date falls if the week and year of the "Due" date are the same as today's week and year (e.g. Mon, Tue, Wed, etc.). If the "Due" date is not in this week, it returns a null value. Some people have reported that this code does not work for this reason. You can try selecting a date from this week and a date from next week.
@louiseh7302 If you want to stay within the boundaries of the planned week, this code works: if( and( formatDate(prop("Due"), "W") == formatDate(today(), "W"), formatDate(prop("Due"), "Y") == formatDate(today(), "Y")), formatDate(prop("Due"), "ddd"), "" ) But if we want to specify the day independent of the planned week, this formula will suffice: formatDate(prop("Due"), "ddd") I hope this helps a bit.
@@creative_cove This formula returns the day of the week on which the "Due" date occurs if the week and year of the "Due" date are the same as today's week and year (for example, Mon, Tue, Wed, etc.). If the "Due" date is not in this week, it returns a blank value. This way, only the days of tasks that are in this week are displayed.
formula in space enter format date is not working,maybe this tutorial is meant for your notion template i think,waste of time,kindly mention template tutorial ,
Hi, this tutorial is not for a template of mine, it’s a stand alone tutorial. I have pasted the formula into the comments for anyone having trouble with it 😊
I accidentally came across your video and subscribed immediately. Amazing tutorial. I'm very impressed how Notion's advanced since I started using it approx. 8 years ago.
Thank you! I appreciate your support :)
Thank you so much! I've been searching for this for 3 days now 😅
Thankyou for this video. I already created my weekly planner thanks to your tutorial. You've helped me a lot.
You are so welcome! thanks for watching 😊
I recently found your channel and have been binge-watching it. The content is amazing! Keep up the great work and continue growing.
Thank you! I really appreciate your support :)
I always learn something new from your videos - like this formula for example. You never disappoint 😊
Keep up the good work 😊🙏🏼🌟
Thanks! 😃
The best tips ⚡! +1
I really appreciate your content 😍.
This is so helpful! Thank you for sharing!!
Glad it was helpful!
Thank you for your informative and educational videos.
Thank you! So helpful!🙂
This is exactly what I wanted to do! Thank yooou :D
No problem!
It is very very helpful. Thank you so much ! You've got one new subscriber there !
Awesome, thank you! Really appreciate your support 😊
Excellent
I am new to notion. Do you like clear up this list for reusing for the next week or do you do something else?
I need some help... The formula is not working for me, I don't know why.
thankssss👏
¡Excelente video!
¡Muchas gracias!
Can I assess the previous weeks from this weekly planner setup?
This is really helpful. I'm trying to set my calendar up so instead of 'day of the week' it's showing me tasks due that week out of 12 week period. (so the 'Day' that you have would be 'week' for me). How would I go about changing the formula for this?
okay if I want to make this type of schedule for every month separately how to do it? And how to reschedule pending tasks? Please answer
Thank you for this. A very well thought out formula!
I have been using a time blocker designed from your tutorial for a related and near similar function and one thing I came to realize is that it would be really handy to see the events for that week. I do have a separate events database for exams, CATs and birthdays but I don't think notion can allow you to show properties from different databases in single calendar view. (Unless its the "home" page I hear) That's where I think Notion calendar would come in handy. I've never used though so allow me to ask if you have any opinion on it?
Yes, the separate Notion calendar app does allow you to view different databases using one view so it could be worth checking out. It's pretty easy to set up (you just have to make an account and connect your Notion).
I love this video and I love my new weekly layout I just have 1 problem I dunno how to fix ! I did mines for 7 days and when I imput the formula for Sunday it pulls the Sunday that past and not the Sunday that’s coming up because my week starts on a Monday and notion week start on a Sunday and I dunno how to tell it to pull the upcoming Sunday and not the past one?
I’m having the same issue 😞
You can change the start date of notion in the settings to a Monday start
Thank you so much for such a great tutorial! Just wondering...how could I edit the formula for the week to start on Monday, without the task list recognizing the Sunday from the week before? Also I'm not able to add tasks straight from the calendar, do you know how I could fix this? :)
You can change the settings within Notion. Click 'Settings & members' in the side bar then 'Language & region'. You can then toggle on 'start week on Monday' and it should update like mine.
I've noticed there's a bit of a glitch sometimes with the calendar. Sometimes the plus symbol to add tasks doesn't show up. Usually, if you refresh the page it resets and shows up 😊
Even after changing my week to start on Monday, the list still only seems to be recognizing the Sunday prior to the current Saturday...
Got the plus symbol to work on the calendar :) thank you so much! Really appreciate it
Hello dear,
Hope you are well. I am facing a problem.I am a student, to make my study organised I am using this weekly planner.So, I input my study data in database before the date comes. Well, I can enter but only in the Saturday and Sunday column. I started my week from saturday . But when I try to my Monday study data and put the date in the due, it doesn't show me which day it is.thats why it doesn't show on the column too. Now I am not getting it why its happening.
Hope you'll be kind enough to look at my problem and help me out.
Thank you~
Your video helps me a lot❤
Your channel is so wonderful. I'm comfortable with Notion now but your ideas are always great, and you're so clear in your explanations!
One question - I tried using the week formula on my own journal templates. However, I found that Sunday counts as the first day of the week (even though I have set my week start to Monday). I'm guessing this is because of the ISO week number - but is there an easy way to sort this?
Thank you! I'm glad you're enjoying the videos. Mine does start on the Monday - do you have the settings within Notion set to start your week on a Monday. You can check by clicking 'Settings & members' in the sidebar then 'Language & region'. Make sure 'Start week on Monday' is toggled on. 😊
@@creative_cove unfortunately I already have that setting on. The issue is with format date. For example 27/07/24 is shown as week 30, and 29/07/24 is week 31, but 28/07/24 (the Sunday) is showing as week 31, whereas I want it to say 30.
@@RainyorSunnyEnding made a new formula property and this is the code i used:
if(
formatDate(prop("Due"), "W") == formatDate(dateSubtract(today(), 7, "days"), "W"),
formatDate(prop("Due"), "ddd"),
""
)
basically subtracts the week
@@creative_cove found a problem with my code it freaks out on Sundays but here is the code.
For formula property for Monday through Saturday:
if(
if(
formatDate(today(), "ddd") == "Sun",
formatDate(dateSubtract(prop("Due"), 1, "weeks"), "W"),
formatDate(prop("Due"), "W")
)
== formatDate(today(), "W"),
formatDate(prop("Due"), "ddd"),
""
)
For formula property for Sunday:
if(
if(
formatDate(today(), "ddd") == "Sun",
formatDate(prop("Due"), "W"),
formatDate(dateSubtract(prop("Due"), 1, "W"), "W")
)
== formatDate(today(), "W"),
formatDate(prop("Due"), "ddd"),
""
)
There might be a way to make both formulas properties into one but for now this is working for me so far
Can u tell me what the prop is on the formula that u posted
@@louiseh7302 it just stands for ‘property’. Notion adds it in when you copy and paste to indicate that something is a property. In this case it was the ‘Due’ property 😊
Girl you make epic shits! Appreciate it 💪🏻
hi, could you help me please . I can't add tasks to the calendar directly.
I've noticed there's sometimes a bug with the calendar and the plus symbol to add tasks doesn't always show up. Usually, if you refresh the page it should reset and allow you to add the tasks 😊
I have seen where others are having trouble with the formula. I tried what you did in the video and I tried what you copied and pasted in the comments. Neither are populating anything in the database. Any suggestions for modifications?
You can copy & paste the following:
if(and(formatDate(prop("Due"), "W") == formatDate(today(), "W"),
formatDate(prop("Due"), "Y") == formatDate(today(), "Y")),
formatDate(prop("Due"), "ddd"),"")
It may not have worked if your properties are named differently. E.g. 'prop' in the formula stands for property and the "Due" is the name of the property.
You may need to delete 'prop("Due")' from the formula and manually select your own Due date property for it to work. 😊
@@creative_cove OMG! Thank you!
I don't know why the tasks don't appear on the calendar. any idea what the problem could be?
They should appear on the calendar as long as you have set up the calendar as a linked view database (and not just a brand new database) and you have the date property filled out for each task 😊
When I make the formula it’s not working, I make all the same steps like you
and when I click on formatDate it’s not turn in to the function
Try copy and pasting the formula:
if(
and(
formatDate(prop("Due"), "W") == formatDate(today(), "W"),
formatDate(prop("Due"), "Y") == formatDate(today(), "Y")),
formatDate(prop("Due"), "ddd"),
""
)
You just need to ensure the date property is labeled the same as mine as 'Due'. 😊
Can you send me this template please ?
Formula doesnt work, ive tried 3 times step by step
It should work, try copy and pasting the formula directly:
if(
and(
formatDate(prop("Due"), "W") == formatDate(today(), "W"),
formatDate(prop("Due"), "Y") == formatDate(today(), "Y")),
formatDate(prop("Due"), "ddd"),
""
)
Just make sure that the date property has the same name as mine 'Due'.
@@creative_cove This formula returns the day of the week on which the "Due" date falls if the week and year of the "Due" date are the same as today's week and year (e.g. Mon, Tue, Wed, etc.). If the "Due" date is not in this week, it returns a null value. Some people have reported that this code does not work for this reason. You can try selecting a date from this week and a date from next week.
@louiseh7302
If you want to stay within the boundaries of the planned week, this code works:
if(
and(
formatDate(prop("Due"), "W") == formatDate(today(), "W"),
formatDate(prop("Due"), "Y") == formatDate(today(), "Y")),
formatDate(prop("Due"), "ddd"),
""
)
But if we want to specify the day independent of the planned week, this formula will suffice:
formatDate(prop("Due"), "ddd")
I hope this helps a bit.
@@creative_cove This formula returns the day of the week on which the "Due" date occurs if the week and year of the "Due" date are the same as today's week and year (for example, Mon, Tue, Wed, etc.). If the "Due" date is not in this week, it returns a blank value. This way, only the days of tasks that are in this week are displayed.
Nothing went on the formula property when I first tried, and when I used the new task button it didn't show up on the planner either
formula in space enter format date is not working,maybe this tutorial is meant for your notion template i think,waste of time,kindly mention template tutorial ,
Hi, this tutorial is not for a template of mine, it’s a stand alone tutorial. I have pasted the formula into the comments for anyone having trouble with it 😊
The formula is not working. The only day it recognizes is Sunday.
Are the tasks dated in the current week? As the formula is designed to only work for tasks within the current week 😊