Once again you have shown yourself to be the most rigorous and illuminating person addressing Notion on TH-cam. I say this with great confidence having reviewed most of the high visibility Notion videos. Anyone who wants to learn tested techniques rather than aspirational plans for Notion should rely on you exclusively.
this is so incredible, thanks so much for yet another excellent video -- my experience of notion has been so transformed by this channel, thank you so much!
Amazing offering, as usual. Thank you so much for this. I wish there was a tip jar somewhere for us to pay you what we think is fair because I feel a little guilty taking this for nothing. You are awesome.
I come straight to your videos when I have a notion issue. This one I used to create a weekly schedule for my college assignments. Stole the Day of the Week formula and the super awesome formula for the Week that way I did not have to filter within a week in general. I don't want to see next Monday's things on Tuesday of this week so you saved my life.
Excellent as usual ! And a very nice idea. By the way ... instead of substracting 1 day in your formula for having it starting automatically on Monday, just format the date with W in uppercase and it will do the job: formatDate(prop("Date"), "W") == formatDate(now(), "W")
Red Gregory hits it out of the park again with this video. I have long had a frustration with one of my pages showing "next week's Monday appointment" on "this week's" page because today is Wednesday. This formula helped keep only this week's data showing.
I have a suggestion for you. I have two rows: 1. January 1st, 2023 2. January 1st, 2022 When I applied the current month logic, the second row was there, which it shouldn't be. I recommend changing the code from: formatDate(prop("date"), "M") == formatDate(now(), "M") to: formatDate(prop("date"), "M") == formatDate(now(), "M") and prop("CurrentYear") == true
Thanks, learnt a lot from this, especially pasting into a table. I also like to display last week. In the formula to highlight Last Week I found I had to subtract 0 to make it work. I am sure there is a better/simpler way, but this worked for me: toNumber(formatDate(dateSubtract(now(), 1, "days"), "w")) - 1 == toNumber(formatDate(dateSubtract(prop("Date"), 1, "days"), "w")) - 0
Awesome! I may have to steal that. ;) As long as it works it's a good formula. I'm not overly concerned about simplicity when I create databases usually.
WOW! That's a lot of information to digest. I love it! I'm definitely going to use the template and see how much more organized I can be. Thanks for sharing. Signed new subscriber.
This is great. Thank you. Your work, written and videos, has taught me so much about Notionl and how to use it in creative ways. I know you have helped and taught thounds like. Again, Thank you.
What a great way to get all the year days quickly... I would do the formula for the name also in excel and save myself an additional property in Notion, but that was great!!!
This is just incredible for logging daily journals and to-do lists but I have one question. How can I replicate the same template for a different year (say 2020)? I have daily journals logged for earlier years but in someplace else and I want to copy/paste those journals in the same template you made without building it from scratch as you did in the video?
This is such a great template! Do you think you can share us the same template for 2022? Or make a video about how to replicate this template for a different year? Thank you Red :)
Thank you so much for this video and template! I really have been struggling trying to make daily planners and to-do lists in notion, but I feel like this automatic system will work perfectly :D
Oh my God, I absolutely LOVE YOU for doing this! Really! It makes life so much easier and it makes so much more sense to get organized this way on Notion! Thank you so much!!!! S2
I am so happy to have found you and your clear, well-structured information and great presentation. This video will helo me to solve one problem and then I am off to watch the rest of your generous share of knowledge. THANK YOU so much
Thank you so so so much!!!!!!, this helped me a lot. I wish you could have a lot more recognition because you do the job well done :))) love all your videos ❤❤❤
amazing work, and thank you so much for your contribution. if I may ask how the formulas work, thankfully you've already provided the formulas, but how i gonna use them, to have the yearly, monthly, and weekly calendar exactly the way you showed in the video. thank you
It is really nice! A great template! I just wonder, how could I order the months differently. January - March, April - June, July - September, October - December instead ofJanuary - April, May - August, September - December. Im just a beginner and I can’t just drop it in (idk why).
Hello there, love the videos. One question i have is there a way to add an icon to each day automatically. Or after the fact. I used your technique to fill out the dates for the rest of 2022. But i want to have a little red book icon for my journal. Wasn't sure if there was some formula or code that would let me add it to like 300 entries. haha. Thanks for your help. Keep up the great work.
"....and then I went down a notion rabbit hole.... that lead me to Red Gregory who had already gone down that rabbit hole and created the solution for me" ⤵️ 🕳 🐇 💙
Thanks so much for your notion videos, they are easy to follow and very useful. A quick question, if I want to set up the page content for each day to have the same format, is there a way to apply to all 365 days rather than clicking into each and then pasting?
Hey Red. A super smart way of reducing friction while using Notion to plan 👏🏻. I have a doubt, about using the dateSubtract formula for finding the week # (week starting from Monday) results in the days before the 1st Monday of Jan being counted as '52nd week'. I'm unable to find a way around it. Can you help me with this?
Using this formula formatDate(prop("Date"), "W") == formatDate(now(), "W") I have events that were THIS week LAST year showing up. How would I fix that? Thanks
So... did I get it right? Is there a better formula? and(formatDate(prop("Event Date"), "YY") == formatDate(now(), "YY") , formatDate(prop("Event Date"), "W") == formatDate(now(), "W")) if(prop("Event Date")
Yes, if you have multiple years using the and function to find common year AND common week is a good idea. You can also say: year(prop(“date”)) == year(now()) for the year
hi red! really love your content! Tried this template and just noticed that using this is quite sluggish vs your other templates. how do i speed up the loading time using this template?
This is great thanks for Sharing. I have one question when I copy and paste from Google Sheets to the Notion Date Field - it's blank before and when I paste - it looks like it paste as it highlights all the rows but it's blank - do you know why this may be? Thanks.
Hi Red and thank you for your video. I believe something you did not cover is how you made the progress bar? I am curious as that would be useful for other contexts as well and cannot find the point in the video in which you set that up. (Not sure whether you can answer this question with a simple comment but please let me know if you have other videos explaining how to display a progress bar similar to the one in this video) Thanks!
Why it didn't work? I try to copy and paste the date in the Notion Database, but the didn't paste everything. I copy the fist 120 Days and paste them. Notion but Notion shows not tho whole days I put inside. Instead it shows me Days I never paste... Could someone help me?
Hey, for the current week. I did the same, but Dec 27 was Week 1. I guess it’s better to subtract 8 days in this case. Jun 1 is 22nd week when the formula shows 23, I think that -8 days is the solution
Is there a way to automatically create the relation of the Journal table to another table? I have several tables with the date as date data type and text data type (formatted in various ways); and I want to link it to this table.
After I discovered your channel, my Notion has never been more organized and complete!
Same. Got here the answers for things i struggled for a long time
u know what is more incredible? this girl makes the best notion templates i've ever seen, and yet those templates don't cost anything...
Red you are saving my LIFE here I was getting so frustrated with trying to get an automatic current week view 😭
Once again you have shown yourself to be the most rigorous and illuminating person addressing Notion on TH-cam. I say this with great confidence having reviewed most of the high visibility Notion videos. Anyone who wants to learn tested techniques rather than aspirational plans for Notion should rely on you exclusively.
this is so incredible, thanks so much for yet another excellent video -- my experience of notion has been so transformed by this channel, thank you so much!
Omg the current week formula is genius, might try it in my master task database
👁️👁️
Amazing offering, as usual. Thank you so much for this. I wish there was a tip jar somewhere for us to pay you what we think is fair because I feel a little guilty taking this for nothing. You are awesome.
check her website, there's a "buy me a coffee" option
Wow! I had given up on figuring out how to automatically filter my daily agenda to show only this week. This is amazing! Thanks!
I come straight to your videos when I have a notion issue. This one I used to create a weekly schedule for my college assignments. Stole the Day of the Week formula and the super awesome formula for the Week that way I did not have to filter within a week in general. I don't want to see next Monday's things on Tuesday of this week so you saved my life.
Excellent as usual ! And a very nice idea. By the way ... instead of substracting 1 day in your formula for having it starting automatically on Monday, just format the date with W in uppercase and it will do the job:
formatDate(prop("Date"), "W") == formatDate(now(), "W")
Good catch. Thank you!
"I’d have to change it every single week". Me watching like "hmm that’s exactly what I do" 😂
Red Gregory hits it out of the park again with this video. I have long had a frustration with one of my pages showing "next week's Monday appointment" on "this week's" page because today is Wednesday. This formula helped keep only this week's data showing.
Magic ... that saves so much work.. now to transform my Daily Habit Tracker
This is gold. I have been looking for a way to pre-fill my habit tracker with dates and days. I'm implementing this right now.
I have a suggestion for you. I have two rows:
1. January 1st, 2023
2. January 1st, 2022
When I applied the current month logic, the second row was there, which it shouldn't be. I recommend changing the code
from:
formatDate(prop("date"), "M") == formatDate(now(), "M")
to:
formatDate(prop("date"), "M") == formatDate(now(), "M") and prop("CurrentYear") == true
Thanks so much! This was exactly what I was looking for!
Thanks, learnt a lot from this, especially pasting into a table.
I also like to display last week. In the formula to highlight Last Week I found I had to subtract 0 to make it work. I am sure there is a better/simpler way, but this worked for me:
toNumber(formatDate(dateSubtract(now(), 1, "days"), "w")) - 1 == toNumber(formatDate(dateSubtract(prop("Date"), 1, "days"), "w")) - 0
Awesome! I may have to steal that. ;) As long as it works it's a good formula. I'm not overly concerned about simplicity when I create databases usually.
Yeah Red, I have to say this video in particular was gangsta :-)
Most underrated YT channel :(
Сара, ты гений! Спасибо за восхитительные видео!
I can't thank you enough.. you helped me sort out my life with your free lectures on notion....
You are so committed omg
WOW! That's a lot of information to digest. I love it! I'm definitely going to use the template and see how much more organized I can be. Thanks for sharing. Signed new subscriber.
it is mindblowing, i was thinking about design like this but this approach is much more easier. Thank you very much!
This is great. Thank you. Your work, written and videos, has taught me so much about Notionl and how to use it in creative ways. I know you have helped and taught thounds like. Again, Thank you.
Thank you so much for sharing this video! :) You upgraded my Notion life!
What a great way to get all the year days quickly... I would do the formula for the name also in excel and save myself an additional property in Notion, but that was great!!!
This was super helpful and allowed me to beef up my daily journal and save some time in the future. Thanks for that!
This is just incredible for logging daily journals and to-do lists but I have one question.
How can I replicate the same template for a different year (say 2020)? I have daily journals logged for earlier years but in someplace else and I want to copy/paste those journals in the same template you made without building it from scratch as you did in the video?
Brilliant! I've just started using Notion as a LifeOS and I HAVE TO ADD THIS! Thank you!!
This is such a great template! Do you think you can share us the same template for 2022? Or make a video about how to replicate this template for a different year? Thank you Red :)
@@evellynneves9927 I can't understand u TT
thanks for your toughts and recommendations, useful as always!
You are the Notion Angle, thaank you for this insight!!!
The current week trick is brilliant. Thank you!
제 노션은 이 채널을 알기 전과 후로 나뉩니다..
반갑습니다 ㅋㅋ
Thank you so much for this video and template! I really have been struggling trying to make daily planners and to-do lists in notion, but I feel like this automatic system will work perfectly :D
This channel is amazing. Really good content
Oh my God, I absolutely LOVE YOU for doing this! Really! It makes life so much easier and it makes so much more sense to get organized this way on Notion! Thank you so much!!!! S2
Really thank you for your sharing, I've watched many videos from your youtube, very helpful! Thank you. ❤️❤️❤️
I am so happy to have found you and your clear, well-structured information and great presentation. This video will helo me to solve one problem and then I am off to watch the rest of your generous share of knowledge. THANK YOU so much
This is brilliant! Thank you so much for this video- it's just what I'd been looking for!
This is so incredible. You help me a lot in organizing my notion. Thanks a bunch, Red
Very clear and straightforward. Loved it!
Thank you! Your videos are great and this especially helps me in my new year Notion overhaul 👍🏻
You are a queen of notion!!!
Another amazing video, THANK YOU!
I love your videos and templates. Thank you so much for sharing. You have helped me tremendously :)
Super cool, good job and thanks for the time !
Thank you so so so much!!!!!!, this helped me a lot. I wish you could have a lot more recognition because you do the job well done :))) love all your videos ❤❤❤
OMG that video was amazing! Thaaanks!
You are just too brilliant. Thank you for teaching this.
Amazing work. Congratulations!
thank you sm this was super helpful !!!
im new in notion. thank you! :)
u really deserve more subs
Amazing again! Fantastic! Thank you!
Thanks so much !!! Love you ❤❤❤
Unfortunately, I am unable to paste date data from Excel into Notion date properties. I don't know why this is happening. Please help.
amazing work, and thank you so much for your contribution. if I may ask how the formulas work, thankfully you've already provided the formulas, but how i gonna use them, to have the yearly, monthly, and weekly calendar exactly the way you showed in the video. thank you
This is amazing! Thank you!
This is super cool!! Thank you so much :-)
It is really nice! A great template! I just wonder, how could I order the months differently. January - March, April - June, July - September, October - December instead ofJanuary - April, May - August, September - December. Im just a beginner and I can’t just drop it in (idk why).
Hello there, love the videos. One question i have is there a way to add an icon to each day automatically. Or after the fact. I used your technique to fill out the dates for the rest of 2022. But i want to have a little red book icon for my journal. Wasn't sure if there was some formula or code that would let me add it to like 300 entries. haha. Thanks for your help. Keep up the great work.
Thank you so much for this tutorial! Love it
Thank you for posting this. Very interesting.
"....and then I went down a notion rabbit hole....
that lead me to Red Gregory who had already gone down that rabbit hole and created the solution for me" ⤵️ 🕳 🐇 💙
great job. Thank you very much
That really saves me
Thanks so much for your notion videos, they are easy to follow and very useful. A quick question, if I want to set up the page content for each day to have the same format, is there a way to apply to all 365 days rather than clicking into each and then pasting?
Thank You Sarah
Hey Red. A super smart way of reducing friction while using Notion to plan 👏🏻. I have a doubt, about using the dateSubtract formula for finding the week # (week starting from Monday) results in the days before the 1st Monday of Jan being counted as '52nd week'. I'm unable to find a way around it. Can you help me with this?
Hey I had the same problem. It works if u put the subtractDate to "-1" except of "1" -> formatDate(dateSubtract(prop("Date"), -1, "days"), "w")
You are amazing! Thank you!
Using this formula formatDate(prop("Date"), "W") == formatDate(now(), "W") I have events that were THIS week LAST year showing up. How would I fix that? Thanks
So... did I get it right? Is there a better formula? and(formatDate(prop("Event Date"), "YY") == formatDate(now(), "YY") ,
formatDate(prop("Event Date"), "W") == formatDate(now(), "W"))
if(prop("Event Date")
Yes, if you have multiple years using the and function to find common year AND common week is a good idea. You can also say: year(prop(“date”)) == year(now()) for the year
@@RedGregory Don't suppose you can expand on this? Formula isn't working currently (trying to plan an August to August year)
excellent tutorial! Could you share how to paste text on different blocks? when we paste from word to notion coming on same block?
Amazing Video
Your the best!
thanks so much!!
What do I need to do to create this for 2023?
Thanks Mike
OMG this can be a pretty good rip-off of the expensive TimeStripe
For the copy-paste step at 06:13 is there any way to do this with the keyboard? Or is dragging with the mouse the only method? Thank you!
Thank you for your higher education.
But when I want to transfer the days of the year to writing in Excel, it only puts 12 days from each month! Why?
For som reason mine wont past into the date column. any idea what I may be doing wrong?
hi red! really love your content! Tried this template and just noticed that using this is quite sluggish vs your other templates. how do i speed up the loading time using this template?
Thanks!
awesome!
This is great thanks for Sharing. I have one question when I copy and paste from Google Sheets to the Notion Date Field - it's blank before and when I paste - it looks like it paste as it highlights all the rows but it's blank - do you know why this may be? Thanks.
Hi, can someone please help me? I am trying to do this whole thing but in DD/MM/YYYY format and its just not working!
I tried your technique in 5:32 but excel detects my day as month and vice versa, not sure how to adjust it.
Hi Red and thank you for your video. I believe something you did not cover is how you made the progress bar? I am curious as that would be useful for other contexts as well and cannot find the point in the video in which you set that up.
(Not sure whether you can answer this question with a simple comment but please let me know if you have other videos explaining how to display a progress bar similar to the one in this video)
Thanks!
I don't know if she has a video about progress bars, but she has a template on her website
Does anyone knows why when I paste the dates (5:41) from Google Sheets it pastes blank spaces? I can't really figure it out. Same happens with Excel.
Thanks 🙏 How would you use the API if it was available?
Why it didn't work? I try to copy and paste the date in the Notion Database, but the didn't paste everything. I copy the fist 120 Days and paste them. Notion but Notion shows not tho whole days I put inside. Instead it shows me Days I never paste... Could someone help me?
I wanted to replicate the same for 2023? should I make them from scratch or is it possible to do edit the formula?
Hi, have you figured out how to customize the template for 2023 or did you find another solution?
Is there a way to determine which are holiday and change the year? I want to know for my weekly, and monthly cashflow and sales report
Thanks A lot
Hey, for the current week. I did the same, but Dec 27 was Week 1. I guess it’s better to subtract 8 days in this case. Jun 1 is 22nd week when the formula shows 23, I think that -8 days is the solution
You can try this as well. formatDate(prop("Date"), "W")
Hey Red, what would be the formula for ticking last months data base items ?
Is there a way to automatically create the relation of the Journal table to another table? I have several tables with the date as date data type and text data type (formatted in various ways); and I want to link it to this table.
How can i use this in 2022 as replace the 2021
COULD YOU HELP ME HOW TO ADD icon in the formula. i am not able to follow that step. thanks
on mac, right click > Emoji & Symbols, or google "how to add emoji" for your device
What if I have a task from Monday to Wednesday, in my daily view database on tuesday how can it be able to be shown?
I’m still working on my formula know how, but is there a way to update this template for 2022 without doing the most? Thank you for your clarity!
She has a 2022 video
Yes. Found it. Thank you. Very clear.
@@TheReal-HopeBoykinDance sorry but can you tell me the name of that video? The 2022 updated version of this one, i cant find it. Thanks!