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.
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?
@@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’
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: ua-cam.com/users/shortsQHN6isdkdQY?feature=share Hope it helps!
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.
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 Hi, you can checkout the original template here: somethingorganizedtutorials.notion.site/Habit-Tracker-fabf80f0092d46a99f5b27271b73713c?pvs=4
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!
@@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.
@@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.
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))
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!
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.
Thanks for your effort, it's working perfectly
@@naveentm0405 hi, glad to hear that!
yeyy new video! 🎉❤
Hope you enjoyed it! 🎉❤
the monthly progress bar formula not working for me
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.
thanks sist❤
@@lailatul415 you’re welcome! Glad it helps 💕
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?
@@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’
@@somethingorganized Omg that worked, thank you so much!!!
@@KristenWishart You're welcome! I'm glad it worked.
Can you make a tutorial for to do list ?
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: ua-cam.com/users/shortsQHN6isdkdQY?feature=share
Hope it helps!
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?
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.
my habit tracker isn't working. in the gallery its blank. any advice? ty
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!
i checked and the properties are set to shown. maybe i wrote the formula wrong
@@clovever777 Hi, you can checkout the original template here: somethingorganizedtutorials.notion.site/Habit-Tracker-fabf80f0092d46a99f5b27271b73713c?pvs=4
Hii
My monthly progress bar formula and 7-day streak formula aren't working. What should I do?
Btw, really helpful video.
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!
@@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.
@@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 "🐥🐥🐥🐥🐥🐥🐥"
)
)
@@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
)
@@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
)
My progress bar in monthly progress is always at 0
Hi, make sure you have linked all pages in the habit tracker with the monthly progress, link to all 12 months.
@@somethingorganized yes i did link all pages
@@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.
@@somethingorganized thanks for your help and for your info it worked
"
"+
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 "🐥🐥🐥🐥🐥🐥🐥"
)
)
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))