TL;DR: Create a new Notion database, add a checkbox property for each day of the week, and use a formula to show your weekly completion rate. This guide builds a functional, visual habit tracker in under 10 minutes with zero coding.
Step 1: Create the Database
Open Notion and type /database — choose “Table” (full page). Name it “Habit Tracker.” You’ll see default properties: Name, Tags, etc. Rename the first column (the title) to “Habit” (e.g., “Drink water,” “Read 10 pages”). Delete the “Tags” property by clicking it → “Delete property.” Keep “Created time” if you like, but it’s optional.
If you want to dig deeper, check out our guide on Generative Design: The Future of Sustainable Architecture.
Step 2: Add Daily Checkbox Properties
Click the “+” at the far right of the table header to add a new property. Select “Checkbox” and name it “Mon.” Repeat for Tue, Wed, Thu, Fri, Sat, Sun. You now have 7 checkbox columns. Tip: To avoid clutter, click the “•••” on each property → “Hide” if you want a cleaner view, but for now keep them visible.
Step 3: Build a Weekly Score Formula
Add one more property: click “+” → “Formula” → name it “Weekly %.” Click the formula field and paste this code:(toNumber(prop("Mon")) + toNumber(prop("Tue")) + toNumber(prop("Wed")) + toNumber(prop("Thu")) + toNumber(prop("Fri")) + toNumber(prop("Sat")) + toNumber(prop("Sun"))) / 7 * 100
This converts each checkbox (true/false) to 1/0, sums them, divides by 7, and multiplies by 100. The result shows a percentage from 0 to 100.
Step 4: Add a Visual Progress Bar (Bonus)
Want a bar? Add another Formula property named “Bar.” Use this code:if(prop("Weekly %") >= 100, "🟩🟩🟩🟩🟩🟩🟩", if(prop("Weekly %") >= 85, "🟩🟩🟩🟩🟩🟩⬜", if(prop("Weekly %") >= 70, "🟩🟩🟩🟩🟩⬜⬜", if(prop("Weekly %") >= 50, "🟩🟩🟩🟩⬜⬜⬜", if(prop("Weekly %") >= 30, "🟩🟩🟩⬜⬜⬜⬜", "⬜⬜⬜⬜⬜⬜⬜")))))
This shows 7 squares that fill based on your percentage. Copy-paste exactly; Notion handles emoji fine.
Step 5: Quick-Add Habits & Views
Click “New” at the bottom to add habits. For each row, check off days as you complete them. To view only today’s tasks: click the “•••” near the table title → “Filter” → add filter “Today” (e.g., “Mon” is checked). Alternatively, create a “Gallery” view (click “+ Add a view”) to see cards with checkboxes—great for mobile. Tip: Use “Relations” later if you want to link habits to a daily journal, but don’t overcomplicate now.
Step 6: Set a Weekly Reset Reminder
Notion doesn’t auto-uncheck. So create a recurring reminder: click “•••” at the top of your page → “Add reminder” → set every Monday at 8:00 AM with text “Uncheck
Leave a Reply