OMG THANK YOU SOO SOO MUCH!! this habit tracker is a lifesaver. The way you've made it free and easily accessible to everyone is commendable!! Recommending it to all my notion friends!!
There's one thing that i pretty much don't find in any Notion habit trackers, and that is tracking habits that don't need to be repeated every day For example, if I only have working out 3 times a week as an objective, and I achieve it, it will show me 43%, when it actually is 100% of my goal It would be cool to integrate something like that Thank you!
What I have found has worked for me is just making multiple templates. So, if you work out Mon, Wed, Fri, then make 2 templates. One for workout days and one for the rest (or more of you have other habits like that). It might be a bit harder to figure out the % and charts however. but if you only want a % for each day it should work fine!
@@LordBamba I've never used this app - but here are my thoughts. I'm thinking you could create a new database column called "days" where workout days == 1 and rest days == 0. Then a weekly progress bar formula totals the checkbox values if database rows contain 1 within "days" column. Then your line graph x axis could be assigned weeks instead of days. Could be wrong. Open to criticism. Or just set y axis to progress bar values of rows == workout days. Idk
Notion made recent changes in the formula and I think the correct formula now is something like this: round((toNumber(prop("Exercise") == true)+toNumber(prop("Journal")== true)+toNumber(prop("Meditate")== true))/3*1000)/1000
@@bhaveshprajapat8524 I just typed the formula in Word then pasted it, it automatically removed prop. I removed round to make it work. In the end it looks like this (toNumber(A)+ toNumber(B)+ toNumber(C)) /3*1000/1000
Awesome video, I don't have much money and thanks to you I am organizing my life much better. We need to see how you do the weekly review of your second brain. Your systems are extremely useful! I appreciate your educational work, thank you very much.
Thank you!! Your comment saved me. For anyone else needing some help: you have to manually change the "Exercise" to the names of the habits you have, or else the formula will only consider one habit (here above it would be exercise)
For those seeking for a habit tracker that analyzes different habits on different days and can't find videos about it (because they don't exist), the trick is to use the formula. Basically, you just need to change it to identify the current day of the week by adding a new property: the Creation Time (Notion does this by giving each day a number - like Monday is 1, for example), then edit it to get the necessary date formatting and apply the logic. So: if your habits are Exercise (Mon, Wed, Fri) and Reading (Every day), then you need to create a rule (some IFs) for days 1, 3 and 5 (Mon, Wed and Fri) that 100% is the sum of the "toNumber()" of the 2 habits divided by 2 (as shown in the video), and on the other days it will only be the Reading habit. It may seem a little confusing because it requires a considerable amount of programming knowledge.
@@liveluckyking4788 The formula if you want to track habits that don't need to be repeated every day goes something like this. Say you only want to go gym on Monday, Wednesday, and Friday. So Notion automatically assigns each day of the week as a number, with Mon = 1, Tue = 2 ... Sun = 7. To use this we are going to utilise 'day(Date)'. (day(Date) looks at the current date/day of the week and returns a number, so if today is a monday it would return 1, if today is a tuesday it would return 2, etc.) So all you have to do is create an if statement which in notion has 3 parts (condition, what to do if condition is true, what to do if conditon is false): 'if({condition}, {ifTrue}, {ifFalse})', if the condition is true the first value (ifTrue) is returned, if the condition is false, the second value (ifFalse) is returned. Since we are only going gym mon, wed, and fri. The numbers of the week would be 1, 3, 5 respectively. Therefore our condition would be 'if(day(prop("Date")) == 1 || day(prop("Date")) == 3 || day(prop("Date")) == 5, ...' (note: || simply means 'or'). Now we have our condition, we need to figure out what to do with the 'ifTrue' and 'ifFalse' bit. The thing I wrote is a bit clunky but it works. So say we have 3 other habits and the condition is true (so we are going gym), then for 'ifTrue' we would write: round(( toNumber(prop("Wake up at 5am")) + toNumber(prop("Read/Write for 30min")) + toNumber(prop("Study for 3-4 hrs")) + toNumber(prop("Go to the Gym")) )/4*1000)/1000 Now say the condition is false (so its a day we aren't going gym), for 'ifFalse' we would write: round(( toNumber(prop("Wake up at 5am")) + toNumber(prop("Read/Write for 30min")) + toNumber(prop("Study for 3-4 hrs")) )/3*1000)/1000 All we did is removed the 'going to the gym' habit and change the rounding number to 3 (because we had 3 habits). *So all in all the code would look something like this: if(day(prop("Date")) == 1 || day(prop("Date")) == 3 || day(prop("Date")) == 5, round(( toNumber(prop("Wake up at 5am")) + toNumber(prop("Read/Write for 30min")) + toNumber(prop("Study for 3-4 hrs")) + toNumber(prop("Go to the Gym")) )/4*1000)/1000, round(( toNumber(prop("Wake up at 5am")) + toNumber(prop("Read/Write for 30min")) + toNumber(prop("Study for 3-4 hrs")) )/3*1000)/1000)*
Common problems and their fixes (ran into these myself): Problem: The bar chart shows 400% unlike the empty graph Easlo gets in the video Fix: The fix is actually simple. Remove all the data-points he set up in the march sections and the y-axis will adjust and the graph will fix it self once you enter new data on today and upcoming days after you hit refresh! Second problem: You added habits like I did (for example 7) now the graph shows all 7 but it says you're at 700% or 6 and shows 600%. Fix: Got to the view and edit the default template like he shows at 1:32. Make sure to add that portion into the downloaded template as it's not there. Make sure to use the right amount of habits (change 3 to 7 in my case) Hope this helped :)
I did this: round((toNumber(prop("Journaling") == true)+toNumber(prop("Lichttherapie")== true)+toNumber(prop("Subliminals")== true)) + toNumber(prop("Vagusnerv Stimulator")== true) + toNumber(prop("Vagusnerv Übung") == true) + toNumber(prop("Frische Luft") == true) + toNumber(prop("mind. 1l Wasser") == true)) /7 * 100 / 100 but he's not rounding and I have numbers like 14,28715237%.. HELP
@Easlo once we get a habit down after say 60-90 days of consistency and we no longer need to track it cause it's part of our daily routine, how do we store or archive that data while creating new habits? Cause once we delete or update that property field that will throw off our formula and historical data for the last few months. Wonder if anyone else has a solution for this. Thank you for sharing this updated version of your Habit Tracker and Notion2Charts! You really have an eye for clean aesthetics and layout design.
You really nice man, thank you for your help ! Your videos have inspired me to take notes, learning English and get rid of drug addiction and smoking addiction. In the future, when I get my affairs in order, I'll be sure to send you a donation. For now, just thank you.
@@easlohi! this has been a really helpful tutorial. i was wondering if you’d be able to help me? every time i tick my habit as complete, the percentage bar goes up by 100% - since i have 15 habits, it currently adds up to 2066.66666667 (even though it shouldn’t be adding to that even if i was trying to go by the 100%s)
What do you do when you have tracked a habit for a long time and the chart gets too dense? is there a way to make the chart visualise only the past month or 2?
One question.. Can I make the graph cumulative? Some context: I need to create a chart which shows completion of tasks, and the tasks must be cumulative. Let me give an example: I have 100 items to sell, and every day I sell around 5. So in day 1 the graph goes to 5, the next day, the graph goes to 10, and so on. How do I do that?
I put 17 daily habits and followed your formula, but it's showing a lot of decimal places. Is there a workaround for this to reduce it to 1-2 decimal places like yours?
a previous comment fixed this issue for me, here is the formula: round(((toNumber(A) + toNumber(B) + toNumber(C) + toNumber(D) + toNumber(E) + toNumber(F)) / 6) * 100) / 100 just change the letters to what your properties are and the number 6 if you have more or less
Why can't there be a more dynamic formula which checks for the number of properties in a property section without having to hardcode them into the formula.
really awesome! this helped me a lot :) i have a litte question - is it possible to add a second template and use it with different habits ? i mean - yeah it is possible and i can create a second list and stuff, but it automatically has the habits from the first one and when i edit something in the new template - the edits are also in the first one :/
Unfortunately I don’t think that works and it bothers me. But what I’ve done is that I’ve created different views and then you can choose which properties you want hidden or shown in every view. So I have one for daily habits, one for weekly and one for monthly
Thank you so much for the very helpful video. I have a question I want to ask for your help. I would like to create weekly and monthly progress bar based on the daily progress bar that we already have to help me visually my performance. I have struggled couples days finding ways to do that. Do you have any suggestion on doing it? Thank you in advance!!!
few questions i have: 1. Is that possible to show only certain date on the calendar such as i only want to see Oct only? (I added a filter under the calendar but it is still the same) 2. I want to leave every Saturday blank, is there a way to do so? 3. Not all of my habits are in checkbox format, some are in text and number format and it is not showing on the calendar. How to show these non check box habits on the calendar instead of clicking into it?
I'm having a slight trouble with the buttons.. I followed the video step by step until I ran into a slight problem by 2:39. Changed the "is relative to" to "is" as said in the video but on my end the "end date"/"start date" didn't disappear.. So whenever I click on the buttons, they never work.. Is there a way for me to fix this?
I have a problem with the button It checks everything not only the action of today but also of yesterday and the days before and tomorrow and the days after I want it to check today only how can I do that ?
This code worked for some reason... ((toNumber(prop("Name")) + toNumber(prop("Name"))) +toNumber(prop("Name"))) + toNumber(prop("Name")) I hope this helps
Hi there, I took a habit tracking template and added it to my own notion, but I cannot add new habits different from the habits in the template I took. The properties I added do not appear in the list below. I add it as a checkbox but it is still not in the days section below. How should I add them?
I'm feeling so stupid, you explained so well and even with the template I'm not getting it... mine when I go to create a new day deletes itself when I change the date :(
help!! i dont know why my chart on the formula says " ) expected (char 156)" im getting crazy. thanks !! and its not allowing me to hit the DONE button
is it possible to build a habit tracker that only tracks habits some days out of the week, and not everyday? For example if I go to the gym 4 times a week, then going to the gym is not a daily habit, but I don't want only check 4 out of 7 boxes for the week because then it won't show up as 100% complete.
I just published a tutorial video & free template for a flexible habit tracker that makes it possible to set up daily & non-daily habits. You can choose specific weekdays, change it whenever needed, and even pause a habit without it breaking anything. Feel free to check it out! 😊👍
I'm getting stuck with my date in notion2charts. I can get everything to display untill I load my date property. Then my lines disappear. How can.this be?
You will find this portion of the updated video helpful, which shows you how to add a repeating template so you don't have to add a new page every day. th-cam.com/video/8VekNg_vjUw/w-d-xo.htmlsi=WL-ONsAQcb_yQ54E&t=237
The formula if you want to track habits that don't need to be repeated every day goes something like this. Say you only want to go gym on Monday, Wednesday, and Friday. So Notion automatically assigns each day of the week as a number, with Mon = 1, Tue = 2 ... Sun = 7. To use this we are going to utilise 'day(Date)'. (day(Date) looks at the current date/day of the week and returns a number, so if today is a monday it would return 1, if today is a tuesday it would return 2, etc.) So all you have to do is create an if statement which in notion has 3 parts (condition, what to do if condition is true, what to do if conditon is false): 'if({condition}, {ifTrue}, {ifFalse})', if the condition is true the first value (ifTrue) is returned, if the condition is false, the second value (ifFalse) is returned. Since we are only going gym mon, wed, and fri. The numbers of the week would be 1, 3, 5 respectively. Therefore our condition would be 'if(day(prop("Date")) == 1 || day(prop("Date")) == 3 || day(prop("Date")) == 5, ...' (note: || simply means 'or'). Now we have our condition, we need to figure out what to do with the 'ifTrue' and 'ifFalse' bit. The thing I wrote is a bit clunky but it works. So say we have 3 other habits and the condition is true (so we are going gym), then for 'ifTrue' we would write: round(( toNumber(prop("Wake up at 5am")) + toNumber(prop("Read/Write for 30min")) + toNumber(prop("Study for 3-4 hrs")) + toNumber(prop("Go to the Gym")) )/4*1000)/1000 Now say the condition is false (so its a day we aren't going gym), for 'ifFalse' we would write: round(( toNumber(prop("Wake up at 5am")) + toNumber(prop("Read/Write for 30min")) + toNumber(prop("Study for 3-4 hrs")) )/3*1000)/1000 All we did is removed the 'going to the gym' habit and change the rounding number to 3 (because we had 3 habits). So all in all the code would look something like this: if(day(prop("Date")) == 1 || day(prop("Date")) == 3 || day(prop("Date")) == 5, round(( toNumber(prop("Wake up at 5am")) + toNumber(prop("Read/Write for 30min")) + toNumber(prop("Study for 3-4 hrs")) + toNumber(prop("Go to the Gym")) )/4*1000)/1000, round(( toNumber(prop("Wake up at 5am")) + toNumber(prop("Read/Write for 30min")) + toNumber(prop("Study for 3-4 hrs")) )/3*1000)/1000)
This tracker looks really nice. But what if one day I need to track only one or two habits at a one day and the next day I need to add all habits to track?
Super great video thanks for sharing! But please don't shock viewers with this loud music in the end. If you dont want to remove it at least turn it down (or alternative make your voice louder) Also I think this video would be easier to understand for many people if you use more standard English (Nothing against Singlish but it can be difficult to understand for folks who never heard it haha) Keep up the great work!
Hi guys! I did everything, but I have a problem. In notion the chart does not appear, insted writes such text: Application error: a client-side exception has occurred (see the browser console for more information). I would appreciate if someone could help me
Hello! Liked the video! Just got lost at the formula part as I'm not so familiar with this at Notion yet. Mine keep giving me this error: " ) expected (char 96) " Also would love your voice to be a little bit higher than the music! Would aprecciate that! Love your videos! Thanks man!
Hi there, you need to place a ")" to close the formula similar to what we do while using the if condition in excel. That needs to be placed at "character 96" if you count from the left side of the formula. Hope this helps! Let me know if you have any questions. Thanks.
@@theaccountantguy It worked! But I'm still with a problem: When clicking the button nothing happens. It only checkmark my habits if I manually click on " + " to add the template page each day, than it works. If i click on "Exercise" for example it is not creating the "template" and then checking complete. Any way to change this or may be a bug?
for anyone else is the formula not working in oct 26 2023? or is that just me. i tried copying it word for word but it says prop is not defined idk what to do....
it's really appreciating that you show us from scratch how to build this thing thanks for you your beautiful work
OMG THANK YOU SOO SOO MUCH!! this habit tracker is a lifesaver. The way you've made it free and easily accessible to everyone is commendable!! Recommending it to all my notion friends!!
There's one thing that i pretty much don't find in any Notion habit trackers, and that is tracking habits that don't need to be repeated every day
For example, if I only have working out 3 times a week as an objective, and I achieve it, it will show me 43%, when it actually is 100% of my goal
It would be cool to integrate something like that
Thank you!
What I have found has worked for me is just making multiple templates. So, if you work out Mon, Wed, Fri, then make 2 templates. One for workout days and one for the rest (or more of you have other habits like that). It might be a bit harder to figure out the % and charts however. but if you only want a % for each day it should work fine!
@@mothtotheflame13 That's exactly what I'm doing right now. Figuring out how to chart this would be challenging though.
@@mp0wa for sure. hope you figure it out!!
are there some news?
@@LordBamba I've never used this app - but here are my thoughts. I'm thinking you could create a new database column called "days" where workout days == 1 and rest days == 0. Then a weekly progress bar formula totals the checkbox values if database rows contain 1 within "days" column. Then your line graph x axis could be assigned weeks instead of days. Could be wrong. Open to criticism. Or just set y axis to progress bar values of rows == workout days. Idk
If anyone looking for the Formula of updated version- round((toNumber(Meditate)+toNumber(Exercise)+toNumber(Journal))/3*1000)/1000
Saved my life
Thank you so much
marry me
but it just shows 0 at the end?
You're the best! Thank you!
Notion made recent changes in the formula and I think the correct formula now is something like this:
round((toNumber(prop("Exercise") == true)+toNumber(prop("Journal")== true)+toNumber(prop("Meditate")== true))/3*1000)/1000
thank you mate
oh bro, I did this (my notion just delete the prop idk why, is that the mistake?) but now I have 14,3, 14,4; 14,5; 14,6 ... help hahah
thanks a lot m8
thank you !!
@@bhaveshprajapat8524 I just typed the formula in Word then pasted it, it automatically removed prop. I removed round to make it work. In the end it looks like this (toNumber(A)+ toNumber(B)+ toNumber(C)) /3*1000/1000
Awesome video, I don't have much money and thanks to you I am organizing my life much better. We need to see how you do the weekly review of your second brain. Your systems are extremely useful! I appreciate your educational work, thank you very much.
That's works: round((toNumber(prop("Exercise"))+toNumber(prop("Exercise"))+toNumber(prop("Exercise"))+toNumber(prop("Exercise"))+toNumber(prop("Exercise"))+toNumber(prop("Exercise"))+toNumber(prop("Exercise")))/7*1000)/1000
Thank you!! Your comment saved me. For anyone else needing some help: you have to manually change the "Exercise" to the names of the habits you have, or else the formula will only consider one habit (here above it would be exercise)
bro my chart isn't working. Would appreciate if you could help
thank u!
Seriously the best Notion tutorial I've encountered so far, thanks man!
For those seeking for a habit tracker that analyzes different habits on different days and can't find videos about it (because they don't exist), the trick is to use the formula. Basically, you just need to change it to identify the current day of the week by adding a new property: the Creation Time (Notion does this by giving each day a number - like Monday is 1, for example), then edit it to get the necessary date formatting and apply the logic. So: if your habits are Exercise (Mon, Wed, Fri) and Reading (Every day), then you need to create a rule (some IFs) for days 1, 3 and 5 (Mon, Wed and Fri) that 100% is the sum of the "toNumber()" of the 2 habits divided by 2 (as shown in the video), and on the other days it will only be the Reading habit. It may seem a little confusing because it requires a considerable amount of programming knowledge.
tutorial plz
Tutorial ? Or the code?
@@liveluckyking4788 The formula if you want to track habits that don't need to be repeated every day goes something like this.
Say you only want to go gym on Monday, Wednesday, and Friday. So Notion automatically assigns each day of the week as a number, with Mon = 1, Tue = 2 ... Sun = 7. To use this we are going to utilise 'day(Date)'. (day(Date) looks at the current date/day of the week and returns a number, so if today is a monday it would return 1, if today is a tuesday it would return 2, etc.)
So all you have to do is create an if statement which in notion has 3 parts (condition, what to do if condition is true, what to do if conditon is false):
'if({condition}, {ifTrue}, {ifFalse})', if the condition is true the first value (ifTrue) is returned, if the condition is false, the second value (ifFalse) is returned.
Since we are only going gym mon, wed, and fri. The numbers of the week would be 1, 3, 5 respectively. Therefore our condition would be 'if(day(prop("Date")) == 1 || day(prop("Date")) == 3 || day(prop("Date")) == 5, ...' (note: || simply means 'or').
Now we have our condition, we need to figure out what to do with the 'ifTrue' and 'ifFalse' bit. The thing I wrote is a bit clunky but it works. So say we have 3 other habits and the condition is true (so we are going gym), then for 'ifTrue' we would write:
round((
toNumber(prop("Wake up at 5am"))
+ toNumber(prop("Read/Write for 30min"))
+ toNumber(prop("Study for 3-4 hrs"))
+ toNumber(prop("Go to the Gym"))
)/4*1000)/1000
Now say the condition is false (so its a day we aren't going gym), for 'ifFalse' we would write:
round((
toNumber(prop("Wake up at 5am"))
+ toNumber(prop("Read/Write for 30min"))
+ toNumber(prop("Study for 3-4 hrs"))
)/3*1000)/1000
All we did is removed the 'going to the gym' habit and change the rounding number to 3 (because we had 3 habits).
*So all in all the code would look something like this:
if(day(prop("Date")) == 1 || day(prop("Date")) == 3 || day(prop("Date")) == 5,
round((
toNumber(prop("Wake up at 5am"))
+ toNumber(prop("Read/Write for 30min"))
+ toNumber(prop("Study for 3-4 hrs"))
+ toNumber(prop("Go to the Gym"))
)/4*1000)/1000,
round((
toNumber(prop("Wake up at 5am"))
+ toNumber(prop("Read/Write for 30min"))
+ toNumber(prop("Study for 3-4 hrs"))
)/3*1000)/1000)*
is there like a code or smth 😭
I LOVE THIS TEMPLATE! NOTION WHERE HAVE YOU BEEN ALL MY LIFE!
Common problems and their fixes (ran into these myself):
Problem: The bar chart shows 400% unlike the empty graph Easlo gets in the video
Fix: The fix is actually simple. Remove all the data-points he set up in the march sections and the y-axis will adjust and the graph will fix it self once you enter new data on today and upcoming days after you hit refresh!
Second problem: You added habits like I did (for example 7) now the graph shows all 7 but it says you're at 700% or 6 and shows 600%.
Fix: Got to the view and edit the default template like he shows at 1:32. Make sure to add that portion into the downloaded template as it's not there. Make sure to use the right amount of habits (change 3 to 7 in my case)
Hope this helped :)
you're a lifesaver THANK YOUU😭😭🙏🏻
@@hieveryone6074 gotcha
it says 1300% when i check one box off (i have 13 habits), the code is the exact same like he did (except the 13 ofc)
I did this:
round((toNumber(prop("Journaling") == true)+toNumber(prop("Lichttherapie")== true)+toNumber(prop("Subliminals")== true)) + toNumber(prop("Vagusnerv Stimulator")== true) + toNumber(prop("Vagusnerv Übung") == true) + toNumber(prop("Frische Luft") == true) + toNumber(prop("mind. 1l Wasser") == true)) /7 * 100 / 100
but he's not rounding and I have numbers like 14,28715237%.. HELP
@@johanna_wku need to use 7*1000/1000
@Easlo once we get a habit down after say 60-90 days of consistency and we no longer need to track it cause it's part of our daily routine, how do we store or archive that data while creating new habits? Cause once we delete or update that property field that will throw off our formula and historical data for the last few months. Wonder if anyone else has a solution for this.
Thank you for sharing this updated version of your Habit Tracker and Notion2Charts! You really have an eye for clean aesthetics and layout design.
Best Habit tracker video out there!
Thank you, so glad to hear that! Let me know if there’s any feedbacks always!
THANK YOU SO MUCH! I was just missing this and you explained it so straightforwardly!
Could you help me with the formula
@@FurtherFlying try this one:
round((toNumber(Meditate)+toNumber(Exercise)+toNumber(Journal))/3*1000)/1000
@@burugyri Thank you!!
Do you think that you can make a calendar planner template that can be integrated with Google chrome
The notion wisdom feels good.
You really nice man, thank you for your help ! Your videos have inspired me to take notes, learning English and get rid of drug addiction and smoking addiction.
In the future, when I get my affairs in order, I'll be sure to send you a donation. For now, just thank you.
Thats so nice keep pushing man I know its hard
This was really helpful! Cut down the time I would have taken to set up Notion's Habit Tracker template by A LOT!! Thank you! 💗
Best tutorial out there
highly recommended for beginners
What formula did you use to do the progress mine is not working can you pls help??
It's the first time I do this, thanks a lot !!
Awesome video Easlo.
Learned a lot of new things from this.
Thank you Magnus, I'm glad to hear!
Thanks bro! this video is great and helps me a lot!
Thank you too for watching! I’m glad to hear it!
Thank you so much! This is exactly what I was looking for!
I’m really glad to hear! Thank you for watching!
thank you for your simplicity💌
This is absolutely helpful for me, Thanks!
This is the best habbit tracker in notion
Yo bro, could you help me get going with notion. Dont understand much since mine is in a different language..could I dm you on instagram or sum?
Hey, bro. Thank you so much for sharing! 🔥 I was looking for this since a long ago.
Woa, you are simply the greatest!
Amazing video 🚀 it's really helpful, concise and avoid you to buy expensive templates.
Soo much helpful! I loove this template😍
Glad it was helpful!
@@easlohi! this has been a really helpful tutorial. i was wondering if you’d be able to help me? every time i tick my habit as complete, the percentage bar goes up by 100% - since i have 15 habits, it currently adds up to 2066.66666667 (even though it shouldn’t be adding to that even if i was trying to go by the 100%s)
This is really helpful and my life saver. Thank you sooo much!
What do you do when you have tracked a habit for a long time and the chart gets too dense? is there a way to make the chart visualise only the past month or 2?
just came across this videa and it was soo helpful ! However I keep having problems with the buttons not working. Can someone help ?
you saved me, thankyou so much!!
at 2:49 how can i make both buttons appear on the same line? personally when i duplicate it just goes to the next line (sorry typo)
How can I place a Button 2:25
Thank you for the video, I set up my habit tracker!🤗
very Useful Videooo and tutorial very clear..thxxx
thanks a lot for the tips, however do you mind sharing the latest coding since they've updated their formula language?
fantastic video! Thank you!
One question.. Can I make the graph cumulative? Some context: I need to create a chart which shows completion of tasks, and the tasks must be cumulative. Let me give an example: I have 100 items to sell, and every day I sell around 5. So in day 1 the graph goes to 5, the next day, the graph goes to 10, and so on. How do I do that?
Cool, thanks! The music at the end jumps out very loud and disturbing tho
You are amazing!!
Thanks for checking out my video, I appreciate it!
Can you please go a little faster next time? I’d prefer to pause and rewind 47 times instead of the normal 35.
I put 17 daily habits and followed your formula, but it's showing a lot of decimal places. Is there a workaround for this to reduce it to 1-2 decimal places like yours?
a previous comment fixed this issue for me, here is the formula:
round(((toNumber(A) + toNumber(B) + toNumber(C) + toNumber(D) + toNumber(E) + toNumber(F)) / 6) * 100) / 100
just change the letters to what your properties are and the number 6 if you have more or less
Wow many blessings to you. Wonderful tutorial!!! So you know how we can add graphics to templates so they are not just white?
Can you please show me how to build a language study plan on notion?
Do we always have to ''add an item'' on the calendar? Is there an option to do have to open that checkbox space daily? Thx
ok everything works, the only doubt is if it will work forever or will I have to do it for every month of the year?
Great Video, Thanks.
Why can't there be a more dynamic formula which checks for the number of properties in a property section without having to hardcode them into the formula.
really awesome! this helped me a lot :)
i have a litte question - is it possible to add a second template and use it with different habits ? i mean - yeah it is possible and i can create a second list and stuff, but it automatically has the habits from the first one and when i edit something in the new template - the edits are also in the first one :/
ive been looking for an answer to that too and the answer is no, i don't think so. please let me know i fyou find one though !
Unfortunately I don’t think that works and it bothers me. But what I’ve done is that I’ve created different views and then you can choose which properties you want hidden or shown in every view. So I have one for daily habits, one for weekly and one for monthly
very easy to follow and highly intuitive habit tracker. Now all that's left is to actually build the habits, haha.😂
Thank you so much for the very helpful video. I have a question I want to ask for your help. I would like to create weekly and monthly progress bar based on the daily progress bar that we already have to help me visually my performance. I have struggled couples days finding ways to do that. Do you have any suggestion on doing it? Thank you in advance!!!
few questions i have:
1. Is that possible to show only certain date on the calendar such as i only want to see Oct only? (I added a filter under the calendar but it is still the same)
2. I want to leave every Saturday blank, is there a way to do so?
3. Not all of my habits are in checkbox format, some are in text and number format and it is not showing on the calendar. How to show these non check box habits on the calendar instead of clicking into it?
Thanks, bro. I`m so happy)
What to do when i want to embed my link of the chart but my only options are mention block, dismiss, and paste and sync?? Thank you!
I'm having a slight trouble with the buttons.. I followed the video step by step until I ran into a slight problem by 2:39. Changed the "is relative to" to "is" as said in the video but on my end the "end date"/"start date" didn't disappear.. So whenever I click on the buttons, they never work.. Is there a way for me to fix this?
restart the app
Thanks a million!
is there anyway to track by Habit, eg i want to see the percentage of time I exercise that month/week
this video is awesome but I have one question how to move the buttons so that they are horizontal ?
Click the three dots next to a button and drag it alllllll the way to the right edge
This is amazing
Did you hear about notion's update with charts?
Yes I'm going to be updating my templates and make new videos soon!
Can I use different databases for different habits? And how?
thanks a million!
Great video!
It’s showing error to make the chart so I’m unable to create the graph, help me out
how to choose Ascending or Descending in checkbox ???
I have a problem with the button It checks everything not only the action of today but also of yesterday and the days before and tomorrow and the days after I want it to check today only how can I do that ?
How to add Page inside checkbox in daily habit page
Does anyone know the updated version of the formula???
This code worked for some reason... ((toNumber(prop("Name")) + toNumber(prop("Name"))) +toNumber(prop("Name"))) + toNumber(prop("Name"))
I hope this helps
Hi there, I took a habit tracking template and added it to my own notion, but I cannot add new habits different from the habits in the template I took. The properties I added do not appear in the list below. I add it as a checkbox but it is still not in the days section below. How should I add them?
If you click on Properties, are the ones you added hidden? In that case click the eye symbol to show them
How do we make this appear every day on the calendar?
When I embed the Chart it gives me an error every single time. :(
I'm feeling so stupid, you explained so well and even with the template I'm not getting it... mine when I go to create a new day deletes itself when I change the date :(
Try doing it again! I think you may have done something wrong with the buttons
i really dont know but done button refused to work
Can I add list of checkboxes automatically when I press any button with habit, without 'plus' button every day in calendar? ps thx for video
yeah so in the calendar just go into template, add the checkboxes there, and then set it for daily recurring. i think so at least idk
help!! i dont know why my chart on the formula says " ) expected (char 156)" im getting crazy. thanks !!
and its not allowing me to hit the DONE button
try this: round((toNumber(prop("your habit")) + toNumber(prop("your habit")) + toNumber(prop("your habit")) + toNumber(prop("your habit"))) / 4 * 1000) / 1000
Just saw your reel on insta where u told to comment for link !!But didn't recieve any positive response so went on youtube and look gotchu
Thanks man
How can i place a Button at 2:25
is it possible to build a habit tracker that only tracks habits some days out of the week, and not everyday? For example if I go to the gym 4 times a week, then going to the gym is not a daily habit, but I don't want only check 4 out of 7 boxes for the week because then it won't show up as 100% complete.
I just published a tutorial video & free template for a flexible habit tracker that makes it possible to set up daily & non-daily habits. You can choose specific weekdays, change it whenever needed, and even pause a habit without it breaking anything. Feel free to check it out! 😊👍
I'm getting stuck with my date in notion2charts. I can get everything to display untill I load my date property. Then my lines disappear. How can.this be?
Thanks brou!!
Thank you very much
do i need to add every day this to myself or will it add automatic ?
You will find this portion of the updated video helpful, which shows you how to add a repeating template so you don't have to add a new page every day. th-cam.com/video/8VekNg_vjUw/w-d-xo.htmlsi=WL-ONsAQcb_yQ54E&t=237
The formula if you want to track habits that don't need to be repeated every day goes something like this.
Say you only want to go gym on Monday, Wednesday, and Friday. So Notion automatically assigns each day of the week as a number, with Mon = 1, Tue = 2 ... Sun = 7. To use this we are going to utilise 'day(Date)'. (day(Date) looks at the current date/day of the week and returns a number, so if today is a monday it would return 1, if today is a tuesday it would return 2, etc.)
So all you have to do is create an if statement which in notion has 3 parts (condition, what to do if condition is true, what to do if conditon is false):
'if({condition}, {ifTrue}, {ifFalse})', if the condition is true the first value (ifTrue) is returned, if the condition is false, the second value (ifFalse) is returned.
Since we are only going gym mon, wed, and fri. The numbers of the week would be 1, 3, 5 respectively. Therefore our condition would be 'if(day(prop("Date")) == 1 || day(prop("Date")) == 3 || day(prop("Date")) == 5, ...' (note: || simply means 'or').
Now we have our condition, we need to figure out what to do with the 'ifTrue' and 'ifFalse' bit. The thing I wrote is a bit clunky but it works. So say we have 3 other habits and the condition is true (so we are going gym), then for 'ifTrue' we would write:
round((
toNumber(prop("Wake up at 5am"))
+ toNumber(prop("Read/Write for 30min"))
+ toNumber(prop("Study for 3-4 hrs"))
+ toNumber(prop("Go to the Gym"))
)/4*1000)/1000
Now say the condition is false (so its a day we aren't going gym), for 'ifFalse' we would write:
round((
toNumber(prop("Wake up at 5am"))
+ toNumber(prop("Read/Write for 30min"))
+ toNumber(prop("Study for 3-4 hrs"))
)/3*1000)/1000
All we did is removed the 'going to the gym' habit and change the rounding number to 3 (because we had 3 habits).
So all in all the code would look something like this:
if(day(prop("Date")) == 1 || day(prop("Date")) == 3 || day(prop("Date")) == 5,
round((
toNumber(prop("Wake up at 5am"))
+ toNumber(prop("Read/Write for 30min"))
+ toNumber(prop("Study for 3-4 hrs"))
+ toNumber(prop("Go to the Gym"))
)/4*1000)/1000,
round((
toNumber(prop("Wake up at 5am"))
+ toNumber(prop("Read/Write for 30min"))
+ toNumber(prop("Study for 3-4 hrs"))
)/3*1000)/1000)
Amazing !
f I create a chart in chartbase and I share the template, the chart still update with the person statistics?
This tracker looks really nice. But what if one day I need to track only one or two habits at a one day and the next day I need to add all habits to track?
I have windows laptop so i need a 6 habit formula.pls share me
Super great video thanks for sharing! But please don't shock viewers with this loud music in the end. If you dont want to remove it at least turn it down (or alternative make your voice louder)
Also I think this video would be easier to understand for many people if you use more standard English (Nothing against Singlish but it can be difficult to understand for folks who never heard it haha)
Keep up the great work!
Hi guys! I did everything, but I have a problem. In notion the chart does not appear, insted writes such text: Application error: a client-side exception has occurred (see the browser console for more information).
I would appreciate if someone could help me
Hello Easlo. Can you help me by answering my question ? What program do you use to edit that kind a videos ?
Hello! Liked the video! Just got lost at the formula part as I'm not so familiar with this at Notion yet. Mine keep giving me this error: " ) expected (char 96) "
Also would love your voice to be a little bit higher than the music! Would aprecciate that!
Love your videos! Thanks man!
Hi there, you need to place a ")" to close the formula similar to what we do while using the if condition in excel. That needs to be placed at "character 96" if you count from the left side of the formula. Hope this helps! Let me know if you have any questions. Thanks.
@@theaccountantguy It worked! But I'm still with a problem: When clicking the button nothing happens. It only checkmark my habits if I manually click on " + " to add the template page each day, than it works. If i click on "Exercise" for example it is not creating the "template" and then checking complete. Any way to change this or may be a bug?
masterpiece
Bro i don't get 100% in y axis 😢
Loved it. Everything was fine but I believe you're too fast, I watched the video on 0.5X 😅
I can't organize my buttons horizontally, how can I do it? Notion only allowed me to move my buttons in a vertical way.
You can put "columns" to do it how he shows it
@@ramenferrana5147 can you please tell me how to do it my buttons are only moving vertically and not horizontally?
my chart is not working, it is not updating data and show nothing :(
for anyone else is the formula not working in oct 26 2023? or is that just me. i tried copying it word for word but it says prop is not defined idk what to do....