Some time ago (at the start of my Notion discovery) I created this sleep tracker and I can’t believe I haven’t shared it yet. Maybe its simplicity held me back. It is quite straight forward formula. Who knows, maybe you can take some inspiration from this. I created a calculator to return the hour I should go to sleep and a tracker to compare my actual hours slept to my goal. This is all well and good but it’s the dream column that’s providing the most considerable return. I’ve found that nights bad dreams occur are when I sleep too much or I lacked physical activity the previous day. I’m no doctor but maybe this means something? Tracking seemingly insignificant human cycles can at the very least provide more introspection.

Included in this database are the following properties (ML stands for manual labor):

• [ML] Day of week - text ("from one day → next day")

• [ML] Alarm Set - date with time

• Estimated Sleep Time - formula

  • dateSubtract(prop("Alarm Set"), 7, "hours")

• [ML] Went to Sleep - date with time

• [ML] Woke Up - date with time

• Result

  • if(dateBetween(prop("Woke Up"), prop("Went to Sleep"), "hours") > 8, "😳Excessive", if(dateBetween(prop("Woke Up"), prop("Went to Sleep"), "hours") > 5, "😴Decent", if(dateBetween(prop("Woke Up"), prop("Went to Sleep"), "hours") > 3, "🥱Groggy", if(dateBetween(prop("Woke Up"), prop("Went to Sleep"), "hours") >= 1, "😰Poor", if(dateBetween(prop("Woke Up"), prop("Went to Sleep"), "hours") == 0, "🥴All Nighter", "")))))

• [ML] Dreams - text

Customize

The following is how to adjust the Result formula ⤵

Change greater than hours & label in quotations

• if(dateBetween(prop("Woke Up"), prop("Went to Sleep"), "hours") > 8, "😳Excessive"

Change Estimated Sleep Time ⤵

Change number of hours are ideal for you

• dateSubtract(prop("Alarm Set"), 7, "hours")

COPY TEMPLATE