Notion Tutorial | How to Create an EFFECTIVE Habit Tracker with 7 DAY STREAK in Notion

[@Annazzz17]

It took me a while to understand how to make the formulas, but I managed in the end. I feel so proud of myself because I succeeded. Thank you!

[@somethingorganized]

You should feel so proud, that's amazing! 🎉 Formulas can definitely be tricky, but once you get the hang of it, it’s such a rewarding feeling.

[@lanadelreyforlife-d8c]

girl this is the only video in my life where i reduced the playback speed

[@somethingorganized]

Thank you! I'm so glad it helped.

[@naveentm0405]

Thanks for your effort, it's working perfectly

[@somethingorganized]

@@naveentm0405 hi, glad to hear that!

[@Yasashii.Nihongo39]

yeyy new video! 🎉❤

[@somethingorganized]

Hope you enjoyed it! 🎉❤

[@Amy-22]

There are habits that I want, for example, on Monday and others on Friday or Tuesday. How do I adjust them to fit what I did in the video?

[@somethingorganized]

To set habits for specific days, here's a way to adjust them: Add a Total Habit Property: - Create a new property in your tracker with the type Number, and name it something like Total Habit. - For each day, set the total number of habits you'd like to track. For example: Monday: 5 Tuesday: 7 Update the Progress Formula: - Instead of dividing the checked habits by a fixed number, adjust the formula to divide the checked habits by your new Total Habit property. - This way, the progress bar will dynamically adjust based on the total habits for that specific day. If you need help with the formula or setting this up, feel free to ask!

[@larabacara6106]

Hi! Loved the video! I wanted to know if there is a way to reset the monthly progress so that each year they will be empty and ready to be used again?

[@somethingorganized]

Hi! Thank you for watching and loving the video! 😊 To reset the monthly progress for a new year: Clear the Habit Tracker: - Delete all the pages in the habit tracker database to reset it. - Hover to the left of the Name property, where a small box appears. Click it to select all the displayed pages. - Then hit Delete. Speed Up Deletion: - If you have many entries, set the Load Limit to the maximum (100 pages). - To do this, hover over the table, click the ellipsis menu (•••) near the blue button, and adjust the Load Limit. You might need to repeat the steps a few times depending on the number of entries, but once cleared, your tracker will be fresh and ready to go for a new year!

[@larabacara6106]

@@somethingorganized thank you for answering! But I think I didn’t make myself clear (english is not my first language), but I wanted to find a way to keep this years progress and pages but have the monthly progress reset for a new year (without losing the past years progress). I was thinking about making another database with the years and relating them to either the habit tracker or monthly progress, but couldn’t figure out a good way to do so

[@somethingorganized]

Hi, There are a couple of ways to handle this: Separate Template for Each Year - You can duplicate the entire template and create a version for 2024, 2025, and so on. This way, each year’s progress is stored in its own template without overwriting anything. Continue in the Same Template with Adjustments If you want to keep everything in one place but reset for the new year: - In the Monthly Progress database, rename your page name with month and year, December 2024, January 2025, February 2025. - Update the formula in the Monthly Progress section: Replace formatDate("MMMM") == prop("Name") with formatDate("MMMM Y") == prop("Name"). This will ensure it matches the month and year from the Habit Tracker with the new names like "January 2025" in your database. So you can keep tracking habit in the same database.

[@larabacara6106]

@@somethingorganized Thank you so much! Going to try this now!

[@marina.ripapema]

Hii! I know I am a bit late to comment in here but wanted to ask for some help! In the 7 Day Streak formula, is it possible to add something to the formula so it resets if you skip a day on that habit? Because my formula is working, however, if I skip days in any of my habits but then check them again 2 days later, it still show as a streak... Was this understandable? Haha! Thanks!!

[@somethingorganized]

Hi there, in the 7 day streak, it counted the day when you log your habit based on date. If you skip for example Monday, it won't show the streak. So if you do the habit on Wednesday instead on Monday where you skipped it, you should create a new habit page for Wednesday and add the Wednesday date, the streak will not count Monday, because you skipped it but will count Wednesday when you actually do the habit and check your habit.

[@lailatul415]

thanks sist❤

[@somethingorganized]

@@lailatul415 you’re welcome! Glad it helps 💕

[@delilaradwan9415]

the formula for rthe monthly progress is not working and is making a error symbol, can someone help?

[@somethingorganized]

Hi, feel free to copy and paste your formula here, I’ll check it for you

[@auxeriix2560]

the monthly progress bar formula not working for me

[@somethingorganized]

Here are some suggestions for checking: * The formula uses .formatDate("MMMM") which formats dates as the full month name. Ensure this is consistent with how the month name is stored in prop("Name”). * Make sure prop("Name") contains the full month name without the year. If there's any discrepancy in formatting or if it includes the year, the formula won't find a match. * Ensure that the prop("Date") property is correctly set for all entries * Check if the .filter(current.prop("Date").formatDate("MMMM") == prop("Name")) condition is working as expected. If habitLog is empty, the result will be zero. * Make sure the properties (Date, Progress) are linked and correctly populated in all relevant entries. * If habitLog is empty, the formula will return zero. Ensure that the filtering condition is correctly identifying and including the relevant entries for the current month. * Make sure you have linked all pages in the Habit tracker database to the monthly progress * If everything seems correct and it’s still not working, consider testing with a simplified version of the formula or manually checking a few entries to ensure the logic holds.

[@SavannahRoseToomer]

Hi! The formula is not working for me! When I go to / 7 *100 there's no result. also my tonumber is not turning red

[@somethingorganized]

Hi, feel free to copy and paste your formula here, I'll check it for you.

[@chyyyaland4023]

why is the formula for the date for my monthly progress not showing up? How do you suggest

[@somethingorganized]

Hi! Check these few steps: - Make sure all pages in the habit tracker are properly linked to the monthly progress database. - When setting up the formula, be sure to select the date property directly from the list rather than typing it out manually. It will be highlighted in Gray. - Double-check for any typos, especially commas, dots, or brackets-small details can cause the formula to malfunction. - Ensure that all properties used in the formula are named exactly the same across databases so it can pull the data correctly. Let me know if this helps, or feel free to share any specific issues you're still facing!

[@KristenWishart]

Thank you so much for this video! Super helpful! One thing I'm stuck on is that in my 7 day streak, the streak is on the same line as the habit name. I added the " " but there's no line break between them. Any advice?

[@somethingorganized]

@@KristenWishart hi, I’m glad it’s helpful! In the 7 day streak, it’s a gallery view database, make sure to turn on the wrap feature, in the homepage hover over the 7 day streak database click the ellipsis menu (3 dots) , select layout gallery then turn on the ‘wrap all properties’

[@KristenWishart]

@@somethingorganized Omg that worked, thank you so much!!!

[@somethingorganized]

@@KristenWishart You're welcome! I'm glad it worked.

[@RichReality-y2f]

Can you make a tutorial for to do list ?

[@somethingorganized]

I haven't made a long-format tutorial yet, but you can check out my Shorts video on how I create an effective to-do list: kzbin.infoQHN6isdkdQY?feature=share Hope it helps!

[@clovever777]

my habit tracker isn't working. in the gallery its blank. any advice? ty

[@somethingorganized]

Hi there! If your habit tracker gallery is blank, it might be because the properties aren't set to show. Check the gallery view settings to ensure the relevant properties are visible. Click the ellipsis menu (3 dots) at the top right and show all relevant properties. I hope this helps!

[@clovever777]

i checked and the properties are set to shown. maybe i wrote the formula wrong

[@somethingorganized]

@@clovever777 Hi, you can checkout the original template here: somethingorganizedtutorials.notion.site/Habit-Tracker-fabf80f0092d46a99f5b27271b73713c?pvs=4

[@aadifn35]

My progress bar in monthly progress is always at 0

[@somethingorganized]

Hi, make sure you have linked all pages in the habit tracker with the monthly progress, link to all 12 months.

[@aadifn35]

@@somethingorganized yes i did link all pages

[@somethingorganized]

@@aadifn35 here are some suggestions for checking: * The formula uses .formatDate("MMMM") which formats dates as the full month name. Ensure this is consistent with how the month name is stored in prop("Name”). * Make sure prop("Name") contains the full month name without the year. If there's any discrepancy in formatting or if it includes the year, the formula won't find a match. * Ensure that the prop("Date") property is correctly set for all entries * Check if the .filter(current.prop("Date").formatDate("MMMM") == prop("Name")) condition is working as expected. If habitLog is empty, the result will be zero. * Make sure the properties (Date, Progress) are linked and correctly populated in all relevant entries. * If habitLog is empty, the formula will return zero. Ensure that the filtering condition is correctly identifying and including the relevant entries for the current month. * If everything seems correct and it’s still showing zero, consider testing with a simplified version of the formula or manually checking a few entries to ensure the logic holds.

[@aadifn35]

@@somethingorganized thanks for your help and for your info it worked

[@I03-q1d]

will the dates next to the weekdays update automatically or do you have to change it every week? and if so, will the progress still be there?

[@somethingorganized]

If you're logging habits in gallery view, you'll need to manually add the date each day. However, if you use the calendar view (weekly or monthly), when you log a habit, you can select the date, and it will be added automatically. The progress bar will always be there to track your habits.

[@IsabelDigitalJournals]

@@somethingorganized I might need some help to understand. The monthly progress will not stay the same if I change the date on the habit tracker. I need to create new entries in the habittracker, but then the relation with 7 day streak and monthly progress database is unsync. Or am I missing something? 🤪

[@GaurKhyati]

Hii My monthly progress bar formula and 7-day streak formula aren't working. What should I do? Btw, really helpful video.

[@somethingorganized]

Hi, here are a few things to can check: - Make sure you've linked all pages in the habit tracker to the monthly progress and summary. - Double-check that the formula itself matches exactly, as even a small typo can cause it to not work. If you're still stuck, feel free to share your formula here, and I'd be happy to help you troubleshoot!

[@GaurKhyati]

@@somethingorganized I have linked all the pages (as far as I can see). Sorry for the trouble. It's just I'm new to Notion and still getting the hang of things.

[@GaurKhyati]

@@somethingorganized " "+ lets( habit, prop("habit tracker").filter(current.prop("date").formatDate("YYYY-WW") == now().formatDate("YYYYY-WW") && current.prop("exercise")).length(), "exercise "+habit+"-day streak" ifs( habit==1 "🐥" habit==2 "🐥🐥" habit==3 "🐥🐥🐥" habit==4 "🐥🐥🐥🐥" habit==5 "🐥🐥🐥🐥🐥" habit==6 "🐥🐥🐥🐥🐥🐥" habit==7 "🐥🐥🐥🐥🐥🐥🐥" ) )

[@GaurKhyati]

@@somethingorganized lets(habitLog, prop("habit tracker").filter(current.prop("date").formatDate("MMMM")) ==prop("Name")) , habitprogresssum, habitLog.map(current.progress).sum(), habitcount,habitLog.length(), if(habitcount==0,0, round((habitprogresssum/habitcount)*100)/100 )

[@GaurKhyati]

@@somethingorganized lets(habitLog, prop("habit tracker").filter(current.prop("date").formatDate("MMMM")) ==prop("Name")) , habitprogresssum, habitLog.map(current.progress).sum(), habitcount,habitLog.length(), if(habitcount==0,0, round((habitprogresssum/habitcount)*100)/100 )

[@BackwithLiz]

This is how I have mine and it's still not working lets( habit, prop("Habit Tracker") .filter(current.prop("Date").formatDate("YYYY-WW") ==now().formatDate("YYYY-WW") && current.prop("Morning Routine") ) .length(), ifs( habit == 1, "💐", habit == 2, "💐💐", habit == 3, "💐💐💐", habit == 4, "💐💐💐💐", habit == 5, "💐💐💐💐💐", habit == 6, "💐💐💐💐💐💐", habit == 7, "💐💐💐💐💐💐💐")

[@somethingorganized]

It looks like there might be a small issue in the formula! 😊 To fix it, make sure you add a closing bracket at the very end to close the lets() function. Here’s how it should look: lets( habit, prop("Habit Tracker") .filter(current.prop("Date").formatDate("YYYY-WW") == now().formatDate("YYYY-WW") && current.prop("Morning Routine") ) .length(), ifs( habit == 1, "💐", habit == 2, "💐💐", habit == 3, "💐💐💐", habit == 4, "💐💐💐💐", habit == 5, "💐💐💐💐💐", habit == 6, "💐💐💐💐💐💐", habit == 7, "💐💐💐💐💐💐💐" ) ) Also, double-check that you’ve selected the correct properties in your database, as even small mismatches can cause the formula to not work as expected.

[@BackwithLiz]

@@somethingorganized Thank you that worked. I was missing a bracket :)

[@somethingorganized]

You’re welcome! 😊 Glad it’s all working now

[@GaurKhyati]

" "+ lets( habit, prop("habit tracker").filter(current.prop("date").formatDate("YYYY-WW") == now().formatDate("YYYYY-WW") && current.prop("exercise")).length(), "exercise "+habit+"-day streak" ifs( habit==1 "🐥" habit==2 "🐥🐥" habit==3 "🐥🐥🐥" habit==4 "🐥🐥🐥🐥" habit==5 "🐥🐥🐥🐥🐥" habit==6 "🐥🐥🐥🐥🐥🐥" habit==7 "🐥🐥🐥🐥🐥🐥🐥" ) )

[@somethingorganized]

Hi there, inside the ifs function, make sure to add a comma after number and after the emoji, to all conditions for example, ifs( habit == 1 , “🐥”, ) So ifs( A == 1 , (comma) “X” , (comma))