Habit Tracker with Weekly Summary | Notion guide & template

Alex Sherwood
Oct 6 '19 Β· 3 min read Β· 2050 views
πŸ‘‹
This guide shares how to create a habit tracker and total up your results on a weekly basis. You can quickly copy this template into your own workspace by clicking the Duplicate link in the top right hand corner, while logged into Notion. You could adapt this to summarise your results on a monthly and yearly basis too. Just create 'Monthly Summaries' or 'Yearly Summaries' databases and link the daily pages to each of those. It's tempting to make pages your habits and checkboxes your days. But if you do, you won't be able to create summaries / filter by date. If you have any questions feel free to add a comment or ask them here.
πŸ“‘
To copy this template into your own workspace, open this link in a new tab https://www.notion.so/Habit-Tracker-with-Weekly-Summary-Notion-guide-template-29d4cf0629204851a5af72d014982376
Contents

Weekly Summary

  • πŸ”‘ Key
    βœ…X = number of times you completed the habit this week.
    🎯X = your goal for the habit.
    X Completion = % completion of your goal.
    Overall completion = the average completion for all of your goals that week.
πŸ”— Guide

Weekly summaries

NameStart of weekRatingOverall completionπŸƒβ€β™‚οΈβœ…πŸƒβ€β™‚οΈπŸŽ―πŸƒβ€β™‚οΈ CompletionπŸΆβœ…πŸΆπŸŽ―πŸΆ CompletionπŸ§˜β€β™‚οΈβœ…πŸ§˜β€β™‚οΈπŸŽ―πŸ§˜β€β™‚οΈ Completion
WC 7th Oct   5  7  4  
WC 14th Oct   5  7  4  
WC 21st Oct   4  7  5  

Habit Tracker

πŸ”— Guide

Weekly Summary guide


  • 'Overall completion' formula guide
    Formula:
    round((prop("πŸƒβ€β™‚οΈ Completion") + prop("🐢 Completion") + prop("πŸ§˜β€β™‚οΈ Completion")) / 3 * 100) / 100

    You'll need to change the 3 to 4 in this formula if you start tracking another goal.
    The round() bit of the formula rounds your % to keep things tidy. See Notion's guide here.
  • 'Rating' formula
    Formula:
    if(prop("Overall completion") == 0, "😒", if(prop("Overall completion") <= 0.1, "☹️", if(prop("Overall completion") <= 0.2, "😬", if(prop("Overall completion") <= 0.3, "😟", if(prop("Overall completion") <= 0.5, "😐", if(prop("Overall completion") <= 0.6, "πŸ™‚", if(prop("Overall completion") <= 0.7, "πŸ˜€", if(prop("Overall completion") <= 0.8, "πŸ‘", if(prop("Overall completion") <= 0.9, "πŸ’ͺ", if(prop("Overall completion") <= 0.99, "πŸ‘", if(prop("Overall completion") == 1, "πŸ†", "")))))))))))

    Hopefully this is fairly self explanatory but feel free to leave a comment if you have any questions πŸ˜„
You can set a different goal for each habit each week, without having to worry about updating any of the formulas.
You don't need to record the start of the week to make this table work but it'll let you filter your summaries to view specific date ranges + I like to see the range aka the timespan that I've recorded so far.
Use the admin view to quickly check that you've linked every day of your week to the weekly summaries.

Habit Tracker guide

πŸ”— Habit tracker

Create a new page for each day of the week in this table and link it to it's related week, to create the summary for that week.
You can see my guide to the formula for the 'Week' property here.
  • 'Day's completion' formula guide
    Formula:
    round((if(prop("πŸƒβ€β™‚οΈ Run") == true, 1, 0) + if(prop("🐢 Walk dog") == true, 1, 0) + if(prop("πŸ§˜β€β™‚οΈ Meditate") == true, 1, 0)) / 3 * 100) / 100

    You'll need to update this formula to reference any additional properties that you reference and change the 3 at the end of the formula to match the number of checkbox properties in your database.
  • 'Rating' formula
    Formula:
    if(prop("Day's completion") == 0, "😒", if(prop("Day's completion") <= 0.1, "☹️", if(prop("Day's completion") <= 0.2, "😬", if(prop("Day's completion") <= 0.3, "😟", if(prop("Day's completion") <= 0.5, "😐", if(prop("Day's completion") <= 0.6, "πŸ™‚", if(prop("Day's completion") <= 0.7, "πŸ˜€", if(prop("Day's completion") <= 0.8, "πŸ‘", if(prop("Day's completion") <= 0.9, "πŸ’ͺ", if(prop("Day's completion") <= 0.99, "πŸ‘", if(prop("Day's completion") == 1, "πŸ†", "")))))))))))

    This replicates the Rating formula from the Weekly Summary. Hopefully this is fairly self explanatory but feel free to leave a comment if you have any questions πŸ˜„
The 'This week' view will exclude the Sunday of the current week because Notion considers Sundays as the start of the week and the formula doesn't allow for that πŸ™ˆ

Acknowledgements

πŸ™‡
Credit to Vitor Rodrigues for coming up with the structure of the habit tracker table and calendar view.
If you're still learning to use Notion, I'd highly recommend checking out Francesco D'Alessio's courses -
(this is an affiliate link, I'll receive 30% of fees that you pay for if you sign up after using this link)
Updating...

Share on