How To Use Rollups In Notion

[@Alidid]

Thanks again Notion should use your videos on its page, They are simple and understandable for beginners

[@daniellangewisch]

Thanks, Ali. Glad you enjoyed it! Let me know if there are any other specific parts of Notion you’d like me covering.

[@Alidid]

​ Daniel Langewisch if it's possible make more videos about Databases, Formulas, Relations, Rollup in different categories like content hub, knowledge hub, daily routines ... i think it will be useful for beginners because of your teaching skills Apologize for my poor English 😅

[@daniellangewisch]

Will do! Thanks for the feedback!

[@tanyadavis3285]

Could you provide a link to the tracking template you use? I would like to see how the relationships between the weeks and months work. Thanks!

[@sunnysworld2879]

Thanks a lot, although it did take me a while to actually understand the difference between 'relation' and 'rollups' but now I am blown away :D

[@daniellangewisch]

Thanks! I’m glad this helped! 😃

[@JA_YT]

Hi, how do you create the go to bed, the stand up and the overall sleeptime column? THis would be very helpful for me:)

[@daniellangewisch]

So first, I have two "Date" columns that are labeled ToBed and WakeUp. In these fields, I select the date that I am referring to and the time that I either went to bed or woke up. However, those columns aren't very useful for viewing the information because it is formatted like "Aug 01, 2020 10:30pm", where I really just want the time. So, I created a separate column for each and used this formula: slice(format(prop("ToBed")), 12, 21) . Obviously, you replace "ToBed" with "WakeUp" for the second column. This is essentially extracting only the time from the other column so that it only shows the time in this new column. Hope that helps! Let me know if you have any other questions about how to do it!

[@JA_YT]

Daniel Langewisch Ok, and who do you subtract the standup time from the going to bed time?

[@daniellangewisch]

So then, I create a new column for "Sleep Hours" and use this formula: round(dateBetween(prop("WakeUp"), prop("ToBed"), "minutes") / 60 * 100) / 100 . This calculates the time between the time you went to bed and time you woke up, converts it into minutes, and then converts it into hours with a decimal.

[@DboyHamburg]

Thanks for your video. Your example assumes that only one piece per item is purchased. What is the solution if "Jimmy G" needs 2 pairs of shoes?

[@daniellangewisch]

Hey! Thanks for the reply. There are several ways you could solve this. One possible solution would be to create an individual column for each merchandise and then enter the number for how many items the person bought.

[@DboyHamburg]

@@daniellangewisch THX and have a nice christmas time

[@scrollsandtaps]

Small suggestion: Choose to put text of your KZbin video thumbnail towards the left side

[@daniellangewisch]

Thanks for the feedback! That is something I have realized and am going to try to avoid in the future. Appreciate it 😃