You are my idol !! Sunday was looking for the way you see the week with X tasks and you have achieved what I want to lol hufly as you would never have imagined. Millions of thanks !!
Thank you for the explanation👌👌👌 I hope that you show us more use cases with the timeline view to more explore the features and the power of the timeline view. Thanks again and again 🎉🎉🎉
Hi Red, Notion's way of entering dates and times is very slow & cumbersome.. especially if you are time tracking (my work charges in 6 min intervals).. The "@ now" function fixes this, but can only be used in text columns 🤡. The problem then is trying to use the "datebetween" function on these timestamps created via "@ now".. Do you have a function that can extract these text dates so that these timestamps are usuable? Your help would be greatly appreciated.
Thank you very much for this video! Very enlightning. I would like to know if there is a way to align task in the week view table. Like the 8am task from monday is not aligned with the 8am task from thursday etc. Is there a solution to this ?
How can I add a task repeated like 3 or 2 times per week without typing it every single week? ( I wanna make my weekly study language task on specific days every week) I there any formula that makes me able to do that... Thanks 🙏🏼
@@willi87star Adding a third "if" statement should do the trick. Here's my attempt in which I emphasized the three "if" statements and their clauses on separate lines. if(formatDate(prop("Date"), "W") == formatDate(now(), "W"), "This Week", if(toNumber(formatDate(prop("Date"), "W")) == tonumber(formatDate(now(), "W")) + 1, "Next Week", if(toNumber(formatDate(prop("Date"), "W")) == tonumber(formatDate(now(), "W")) - 1, "Last Week", "" )))
Here's another, somewhat more general and simpler formula you might find useful. It returns 0 (zero) for the current week, 1 for next week, and -1 for last week. toNumber(formatDate(prop("date"), "W")) - toNumber(formatDate(now(), "W"))
Take the next week portion of the formula. Copy it. Paste it after the portion you just copied. Change the [+1] to [-1] and [Next Week] to [Last Week].
You are my idol !! Sunday was looking for the way you see the week with X tasks and you have achieved what I want to lol hufly as you would never have imagined. Millions of thanks !!
it always amazes me when you use formulas, very neat, thank you
Seriously Red thanks for your videos , so helpful.
Great video as always, Red. It's so much fun watching you work with Notion's new features.
Thank you for the explanation👌👌👌
I hope that you show us more use cases with the timeline view to more explore the features and the power of the timeline view.
Thanks again and again 🎉🎉🎉
You are amazing, thank you for yet another excellent tutorial
Red, Thank you so much ! Great job, it was very helpful, this exactly what I was looking for !
love Red, thanks a ton 💗💗
Thanks for make my life easier.
🙏
Amazing, thanks!
It's amazing thank you
Excellent.
Hi Red, Notion's way of entering dates and times is very slow & cumbersome.. especially if you are time tracking (my work charges in 6 min intervals).. The "@ now" function fixes this, but can only be used in text columns 🤡. The problem then is trying to use the "datebetween" function on these timestamps created via "@ now".. Do you have a function that can extract these text dates so that these timestamps are usuable? Your help would be greatly appreciated.
Great video!
Thank you very much for this video! Very enlightning. I would like to know if there is a way to align task in the week view table. Like the 8am task from monday is not aligned with the 8am task from thursday etc. Is there a solution to this ?
Thank you so much..
I love you
How can I add a task repeated like 3 or 2 times per week without typing it every single week? ( I wanna make my weekly study language task on specific days every week) I there any formula that makes me able to do that... Thanks 🙏🏼
please make notion template for travel
Can someone direct me to the link where she created the Starter Task manager which she showed in the first part of the video
How to hide the name of the task? On my Database isn't allowed to hide it.
Thanks for this video miss. i need just time managing system task can you please suggest me one of your video .
I have a question. If you want to use the 24-hour time format, how do you put it in the formula?
Great Video! Do you have a formula for last week? Thanks.
Where she added 1 to identify next week, subtract 1 instead to identify last week.
@@SamuelLegrandCox Thank You. I was able to do that. I was asking how to have "last week" in the same formula.
@@willi87star
Adding a third "if" statement should do the trick. Here's my attempt in which I emphasized the three "if" statements and their clauses on separate lines.
if(formatDate(prop("Date"), "W") == formatDate(now(), "W"),
"This Week",
if(toNumber(formatDate(prop("Date"), "W")) == tonumber(formatDate(now(), "W")) + 1,
"Next Week",
if(toNumber(formatDate(prop("Date"), "W")) == tonumber(formatDate(now(), "W")) - 1,
"Last Week",
"" )))
Here's another, somewhat more general and simpler formula you might find useful. It returns 0 (zero) for the current week, 1 for next week, and -1 for last week.
toNumber(formatDate(prop("date"), "W")) - toNumber(formatDate(now(), "W"))
Take the next week portion of the formula. Copy it. Paste it after the portion you just copied. Change the [+1] to [-1] and [Next Week] to [Last Week].
Thx
Such a shame the timeline's table disapears when you drag it inside the callout...
I have a problem with the days of the week from Saturday to Friday, how do I write it in the formula 🥲🥲🥲🥲