Hi peeps: this week: the power of Notion formulas to make beautiful gallery views! PLUS: 📢The 1st 100 people to download can get my prompted Goal Setting & Yearly Review Template for 50% OFF! Just Download on Gumroad HERE: tinyurl.com/42xv7528 & you can integrate it into this build! 🚨Updated Notion Formulas 2.0: Notion updated their formula system since this video was released: here's what they have changed to for this build! Duration In Weeks Formula: dateBetween( End Date, Start Date, "weeks") Total Target Formula: Target Per Week * Duration In Weeks Progress Column Formula: floor((✎✘ Log / Total Target) * 100) / 100 Concat Report Formula: ("✎✘ " + format(✎✘ Log) + " of " + format(Total Target) + " completed") Status Formula: if(✎✘ Log > 0, Concat Report, "⏱ Nothing Logged Yet") Last Logged Formula: ("⏱ Last Logged: " + formatDate( Last Updated, "DD MMMM"))
Thanks for sharing! Yes indeed - these new updates require a video on how the formulas in the series have changed with formulas 2.0!! I just need to learn them too!
Also the formula for Habit Status column is if(prop("Log") >= 0, "Nothing Logged Yet", prop("Concat report")) I enlisted the help of chatgpt for that one, was driving me up the wall!
The concat function does not combine text anymore, according to the formula guide on Notion. I used this to get the desired result. format(prop("✏Log"))+" of "+prop("Total Target")+ " completed "
Very Good! Yes - we can now just insert + "TEXT" in place of concat functions it seems - kind of easier and simpler - but not if you are following the old method! haha - thanks for sharing :)
And u don’t need to use format or prop, u just need to select the Log and press space and add the + and make the same process, it’s really easier than before
Hi Simon, just stumbled upon this video and now I have watched the entire playlist. Just a question though. Do you manually log every time a habit is done through their individual pages? Is there a way to have a checkbox to have it automatically increase the log number? Asking because it would be cumbersome to manually change the number in the Log column for habits scheduled daily. Thank you and I appreciate your content.
I used your first Habit Tracker all of last year, I'm so happy updating to this one for 2023. Thanks for all of the content you put out it is soo appreciated :)
The concat formula is updated a little now because of this weird thing were Notion uses Icons for property headers (instead of emojis), just follow this - concat(format(prop("Log")), " of ", format(prop("Total Target")), " completed ") . I had to do some monkeying around for it to work.
Thanks for the work in providing this step-by-step. I’m sharing my modifications - maybe it will be of help for somebody. I’ve created a new “Habit Tracker” table with three properties: Name, Habit (which is a Relation to “My Habits”) and Date of Action (Created Time). In “My Habits” the Relation from “Habit Tracker” created a new Tracker property; and the Log property I've modified to be a Rollup in relation to Tracker that counts all name Properties. Lastly, I’ve added a button in the “New Habit TEMPLATE” that ads a new page to the “Habit Tracker”. The result is that the Log is incremented automatically by each button-press and I also have a record of each time any particular habit was done. Continued success
Wow, this is incredible. I saw this display method by Marie Poulin in her weekly agenda, but did not understand how it could be implemented and then accidentally stumbled upon your video. Thank you so much for this kind of knowledge.
I made the tracker, but I am a bit confused on how to log the daily actions. Also, is there a way to know what I have completed over the course of the week?
I love your videos. I'm starting using Notion as a teacher. There are not many tutorial out there and I'd like to suggest you to make a serie of notion tutorials for us, mainly how to track attendance of students per day in a group, or formulas to use to check assignments. Thanks
I didn’t know about the feature that allows you to limit the relation to 1 page, and I was so excited when you talked about it, thinking I could get rid of the ugly, space-eating “+ Add Page” link that appears on my iPad under every relation I make… but it doesn’t. Instead, when you click to link another page, it just replaces the page you have already. I really hate that “+ Add Page” button. It took my nice looking properties list where I could see most of what I needed to at a glance, and pushes every line down one, so that I have to scroll to see the information and have a bunch of those buttons visible on the screen (and totally unnecessarily, as most of my relations would only have one line each (for instance, I link yesterday and tomorrow on each page in my daily journal, for easy navigating… there’s only one of those for each day, so the “+ Add Page” button that pops up when I fill in the relation is never going to be used).
Thank you so much for this course. I have been trying to get everything in my life organized and just came across notion. Seemed like the perfect app. Until l tried to create my own system. Downloaded template after template in hopes something would click and I would be able to make their system work for me. I am so glad I came across your page on RUclips. I can not thank you enough for taking the time to break things down into an easy to follow guide that I have been able to adjust to my needs and make work!! Thank you again, I can not wait until the next video comes out. 😊😊
it seems they are continuing to make changes to the coding, it was a bit of a headache but from this date, these are the formulas accepted. Hope this helps others: (make sure the properties are in grey) Duration in Weeks Formula: round(dateBetween("End Date", "Start Date", "weeks")) Total target Formula: Remains the same. Progress Formula: Remains the same Contact report Formula: " ✓ " + ("✓ Log") + " of " + ("Total Target") + " " + ("Completed") Last Logged Formula: "Last Logged: " + formatDate("Last Updated"), "DD MMMM")
Thank you for your in-depth tutorials. Just completed the set up. Very well done tutorial- nicely paced, detailed steps that are displayed effectively, and the layout is aesthetically pleasing, simple, and intuitive. Now on to your next build video. :)
I struggle with first i am building everything but then how do i actually use it. Is there a video for when your done building and then how to use it. From things to do to day, habit, how to start organising your life when the build is done?
Hi Simon, many thanks for making this video series! I just wanted to ask, how do you create buttons to automatically log habits in this system? Thanks again!
Hey there, thank you! Pretty sure I do: but honestly - it was a long time ago so could have been before that feature. Either way: it’s very easy. Link a button to the daily log database and pre-set/edit the relation to the habit you want to log to be added. Make sure you then filter by the current day entry: ideally calling the new daily log @Today. Forgive me if this is wrong: going on memory from the train: but watch my latest habit tracker tour video for the system I’ve made most recently that demos it. Pretty easy!
hey simon, it's all good but there's something i didn't understand, how to add logs to the habits is there a check box dashboard or just edit the log value manually
Yes, currently you just add the number manually - my full template does it by making the log a rollup from adding habits in a daily log related database. I will include this part of the build later in my downloadable sections of the NFS series 👍
Hey Simon I have been following along and ive run into a problem the new formula language does not allow me to use some fuctions like adding text to the concat formulas i really would love to build this thing but i cant because of this please help
Wonderful conent but I am having trouble following along with the formulas. It looks like these don't work anymore after the redisgn of their code system. I'm pretty lost and frustrated. Hope to get a little clarity. Keep up the great work #BuildinPublic
Sorry if I missed something but is there a way to use buttons to add +1 to our Log or do we have to go to the habits dashboard and manually enter the numbers there? Hope that makes sense. Thank you !
If you use the modifications provided above by @AlexandruGheorghiuP you can then add buttons to your dashboard for each habit that will add a page to the "Habit Tracker" which by relation will update your numbers with just one click!
I have to reject partly my comment, sorry guys...the solution with [..] works without giving back any error message but now shows the comma separator between [Text1] , [Text2]...this does not help either...so still struggling with this concat formula as both, a connecting "+" and/or "&" or whatever gives me back an error message. How that can work so differently??? Anyone else facing this issue that a "+" as a connector for different text items does not work either? Would be really happy to fix it...THANKS
The progress formula isn’t working anymore because of the new update formula. There’s decimal numbers on the percentage. Can someone help me fix that? 😭 I have one of your templates Simon, but I wanted to to my own template in an simplest way
Hey Simon, thanks for this. Needed some help, at 3 minutes on the video in the concat formula you click somewhere off camera to get the emojis into the concat formula. Can you let me know where you click to get those emoji's? I use a windows laptop so not sure if its a key on the keyboard you hit to bring up the emoji's or whether it was somewhere on the screen that the camera doesnt show. This is really cool stuff you keep sharing so thank you for that.
No worries. Thanks for watching. Yeah - I go to the edit menu and then click emojis and symbols on the Mac. I think control period might do it on windows. Or just search for where you can bring up emoji and symbols on the Notion app on your computer. :)
The formula is updated a little now because of this weird thing were Notion uses Icons specifically for the formulas, just follow this - concat(format(prop("Log")), " of ", format(prop("Total Target")), " completed ")
Hi, when i try to do concat report in the formula say "Type mismatch "✎✔︎ " is not a Number." The formula i think is correct, concat( "✎✔︎ " format(prop("✎ Log")), " of", format(prop("Total Target")), " completed ")
"... or download a free copy (of a Goals Template) via the video description", but there are just a subscription call and paid templates... Am I just blind?)
It used to be the function button on Mac - I’m not sure if it still works - alternatively go to the edit menu and find emoji and symbols menu from there. :)
I think now formulas 2.0 are out. ‘Concat’ is not as relevant - just try writing + “the thing you want to write” into the formula at the point it should show - it might be that simple. Doing more research on this at somepoint to make a new tutorial. :)
New updates to Notion's formula language are making following along with this a little hellish. Managed to figure out the formulas in the last video after a bit of trial and error. This one is still not working, despite testing all the formulas in the previous comments. Here's what I've got for formula: concat([prop("✏ 𝗫 Log"), " of "], [prop("Total Target"), " completed"]) Which yields this text: 2, of ,105, completed Can't get rid of the commas in the final or the formula doesn't function. Any help much appreciated!
Haha - oh my - yes - I think the changes will have rather messed this up! I’m catching up too! I’ll plan a video for the series on formulas 2.0!!! Cheers. S
Hi peeps: this week: the power of Notion formulas to make beautiful gallery views! PLUS: 📢The 1st 100 people to download can get my prompted Goal Setting & Yearly Review Template for 50% OFF! Just Download on Gumroad HERE: tinyurl.com/42xv7528 & you can integrate it into this build! 🚨Updated Notion Formulas 2.0:
Notion updated their formula system since this video was released: here's what they have changed to for this build!
Duration In Weeks Formula: dateBetween( End Date, Start Date, "weeks")
Total Target Formula: Target Per Week * Duration In Weeks
Progress Column Formula: floor((✎✘ Log / Total Target) * 100) / 100
Concat Report Formula: ("✎✘ " + format(✎✘ Log) + " of " + format(Total Target) + " completed")
Status Formula: if(✎✘ Log > 0, Concat Report, "⏱ Nothing Logged Yet")
Last Logged Formula: ("⏱ Last Logged: " + formatDate( Last Updated, "DD MMMM"))
4:00 my new version is
concat([prop("Log") + " of " + prop("Total Target") + " completed"])
Thank you! This was about to do me in!
Thanks for sharing! Yes indeed - these new updates require a video on how the formulas in the series have changed with formulas 2.0!! I just need to learn them too!
Also the formula for Habit Status column is if(prop("Log") >= 0, "Nothing Logged Yet", prop("Concat report"))
I enlisted the help of chatgpt for that one, was driving me up the wall!
Ga!! Thank you !!! I was feeling defeated but this worked!!
Thanks mike Iam so glade for you
The concat function does not combine text anymore, according to the formula guide on Notion. I used this to get the desired result. format(prop("✏Log"))+" of "+prop("Total Target")+ " completed "
Very Good! Yes - we can now just insert + "TEXT" in place of concat functions it seems - kind of easier and simpler - but not if you are following the old method! haha - thanks for sharing :)
and "Last Logged " + formatDate(prop("Last Updated"),"DD MMMM") for Last Logged
Excellent comment, thx
this was helpful. Thanks!
And u don’t need to use format or prop, u just need to select the Log and press space and add the + and make the same process, it’s really easier than before
Spent ages trying to work out what I was doing wrong, then checked the comments. Doh! Thanks everyone who posted the current method. 👍
Hi Simon, just stumbled upon this video and now I have watched the entire playlist. Just a question though. Do you manually log every time a habit is done through their individual pages? Is there a way to have a checkbox to have it automatically increase the log number? Asking because it would be cumbersome to manually change the number in the Log column for habits scheduled daily. Thank you and I appreciate your content.
I used your first Habit Tracker all of last year, I'm so happy updating to this one for 2023. Thanks for all of the content you put out it is soo appreciated :)
Ah thanks so much! Great stuff!
The concat formula is updated a little now because of this weird thing were Notion uses Icons for property headers (instead of emojis), just follow this - concat(format(prop("Log")), " of ", format(prop("Total Target")), " completed ") . I had to do some monkeying around for it to work.
Cant thank you enough for this comment!!
Thanks! Great update comment! Good spot.
This was getting headache to me haha thanks a lot!
Can't thank you enough
Brenda rules!!
Thanks for the work in providing this step-by-step.
I’m sharing my modifications - maybe it will be of help for somebody.
I’ve created a new “Habit Tracker” table with three properties: Name, Habit (which is a Relation to “My Habits”) and Date of Action (Created Time). In “My Habits” the Relation from “Habit Tracker” created a new Tracker property; and the Log property I've modified to be a Rollup in relation to Tracker that counts all name Properties. Lastly, I’ve added a button in the “New Habit TEMPLATE” that ads a new page to the “Habit Tracker”. The result is that the Log is incremented automatically by each button-press and I also have a record of each time any particular habit was done.
Continued success
Wow, this is incredible. I saw this display method by Marie Poulin in her weekly agenda, but did not understand how it could be implemented and then accidentally stumbled upon your video. Thank you so much for this kind of knowledge.
Building out my dream planner becuase of you! Thank you!
Great stuff! Welcome to the club! Make sure you are on the mailing list for occasional updates on build videos too :)
I made the tracker, but I am a bit confused on how to log the daily actions. Also, is there a way to know what I have completed over the course of the week?
You are one of the best Notion teacher on RUclips. You make each step, including the formulas easy to implement. Thank YOU!!!
Finally, got "create habit tracker" checked off my list! Thank you so much for these 2 wonderful videos. Going to explore some more! (I subscribed! 😁)
Wonderful! Welcome to the channel - spread the word!
I love your videos. I'm starting using Notion as a teacher. There are not many tutorial out there and I'd like to suggest you to make a serie of notion tutorials for us, mainly how to track attendance of students per day in a group, or formulas to use to check assignments. Thanks
I’m thinking of getting into some student and study stuff in 2023 - thanks for the suggestion :)
@@BetterCreating great
I didn’t know about the feature that allows you to limit the relation to 1 page, and I was so excited when you talked about it, thinking I could get rid of the ugly, space-eating “+ Add Page” link that appears on my iPad under every relation I make… but it doesn’t. Instead, when you click to link another page, it just replaces the page you have already. I really hate that “+ Add Page” button. It took my nice looking properties list where I could see most of what I needed to at a glance, and pushes every line down one, so that I have to scroll to see the information and have a bunch of those buttons visible on the screen (and totally unnecessarily, as most of my relations would only have one line each (for instance, I link yesterday and tomorrow on each page in my daily journal, for easy navigating… there’s only one of those for each day, so the “+ Add Page” button that pops up when I fill in the relation is never going to be used).
Thank you so much for this course. I have been trying to get everything in my life organized and just came across notion. Seemed like the perfect app. Until l tried to create my own system. Downloaded template after template in hopes something would click and I would be able to make their system work for me. I am so glad I came across your page on RUclips. I can not thank you enough for taking the time to break things down into an easy to follow guide that I have been able to adjust to my needs and make work!! Thank you again, I can not wait until the next video comes out.
😊😊
Love this! Thanks so much for the feedback: makes it all worth it! Goal Setting build is coming out in a few weeks too :)
You are a brilliant teacher!
it seems they are continuing to make changes to the coding, it was a bit of a headache but from this date, these are the formulas accepted. Hope this helps others: (make sure the properties are in grey)
Duration in Weeks Formula: round(dateBetween("End Date", "Start Date", "weeks"))
Total target Formula: Remains the same.
Progress Formula: Remains the same
Contact report Formula: " ✓ " + ("✓ Log") + " of " + ("Total Target") + " " + ("Completed")
Last Logged Formula: "Last Logged: " + formatDate("Last Updated"), "DD MMMM")
Thank you for your in-depth tutorials. Just completed the set up. Very well done tutorial- nicely paced, detailed steps that are displayed effectively, and the layout is aesthetically pleasing, simple, and intuitive. Now on to your next build video. :)
Great to hear - thanks for watching and great to have you. Please spread the word ! :)
I know this will help me a lot, I needed it! Thanks a lot!
Glad to hear that! Welcome to the channel!
I struggle with first i am building everything but then how do i actually use it. Is there a video for when your done building and then how to use it. From things to do to day, habit, how to start organising your life when the build is done?
woooow you take it to a new level
Thanks my friend - It's been a fun journey!
Love you man! Really helped me a lot! You're the best!
Glad I could help!
Hi Simon, many thanks for making this video series! I just wanted to ask, how do you create buttons to automatically log habits in this system? Thanks again!
Hey there, thank you! Pretty sure I do: but honestly - it was a long time ago so could have been before that feature. Either way: it’s very easy. Link a button to the daily log database and pre-set/edit the relation to the habit you want to log to be added. Make sure you then filter by the current day entry: ideally calling the new daily log @Today. Forgive me if this is wrong: going on memory from the train: but watch my latest habit tracker tour video for the system I’ve made most recently that demos it. Pretty easy!
hey simon, it's all good but there's something i didn't understand, how to add logs to the habits is there a check box dashboard or just edit the log value manually
Yes, currently you just add the number manually - my full template does it by making the log a rollup from adding habits in a daily log related database. I will include this part of the build later in my downloadable sections of the NFS series 👍
Hey Simon I have been following along and ive run into a problem the new formula language does not allow me to use some fuctions like adding text to the concat formulas i really would love to build this thing but i cant because of this please help
Another question. Like meal prepping and planning. Should that be a task or a habit since i want to do it always at the same day in the week?
Wonderful conent but I am having trouble following along with the formulas. It looks like these don't work anymore after the redisgn of their code system. I'm pretty lost and frustrated. Hope to get a little clarity. Keep up the great work #BuildinPublic
Sorry if I missed something but is there a way to use buttons to add +1 to our Log or do we have to go to the habits dashboard and manually enter the numbers there? Hope that makes sense. Thank you !
If you use the modifications provided above by @AlexandruGheorghiuP you can then add buttons to your dashboard for each habit that will add a page to the "Habit Tracker" which by relation will update your numbers with just one click!
I have to reject partly my comment, sorry guys...the solution with [..] works without giving back any error message but now shows the comma separator between [Text1] , [Text2]...this does not help either...so still struggling with this concat formula as both, a connecting "+" and/or "&" or whatever gives me back an error message. How that can work so differently??? Anyone else facing this issue that a "+" as a connector for different text items does not work either? Would be really happy to fix it...THANKS
The progress formula isn’t working anymore because of the new update formula. There’s decimal numbers on the percentage. Can someone help me fix that? 😭 I have one of your templates Simon, but I wanted to to my own template in an simplest way
Hey Simon, thanks for this. Needed some help, at 3 minutes on the video in the concat formula you click somewhere off camera to get the emojis into the concat formula. Can you let me know where you click to get those emoji's? I use a windows laptop so not sure if its a key on the keyboard you hit to bring up the emoji's or whether it was somewhere on the screen that the camera doesnt show. This is really cool stuff you keep sharing so thank you for that.
No worries. Thanks for watching. Yeah - I go to the edit menu and then click emojis and symbols on the Mac. I think control period might do it on windows. Or just search for where you can bring up emoji and symbols on the Notion app on your computer. :)
The formula is updated a little now because of this weird thing were Notion uses Icons specifically for the formulas, just follow this - concat(format(prop("Log")), " of ", format(prop("Total Target")), " completed ")
Any Help on the Last Logged formula. It's not working for me.
Sorry, I just saw this in your description box with your new formulas.
(" Last Logged: " + formatDate( Last Updated, "DD MMMM"))
How to manage time as School student running a business and getting good grades
Hi, when i try to do concat report in the formula say "Type mismatch "✎✔︎ " is not a Number."
The formula i think is correct, concat( "✎✔︎ " format(prop("✎ Log")), " of", format(prop("Total Target")), " completed ")
Maybe add a comma after the second quote mark (before the first "format").
"... or download a free copy (of a Goals Template) via the video description", but there are just a subscription call and paid templates... Am I just blind?)
what do you push while writing formula to insert emoji?
It used to be the function button on Mac - I’m not sure if it still works - alternatively go to the edit menu and find emoji and symbols menu from there. :)
Can anyone help with the concat formula with the 2.0 update? Nothing seems to work for me
I think now formulas 2.0 are out. ‘Concat’ is not as relevant - just try writing + “the thing you want to write” into the formula at the point it should show - it might be that simple. Doing more research on this at somepoint to make a new tutorial. :)
This video needs updatinf
New updates to Notion's formula language are making following along with this a little hellish. Managed to figure out the formulas in the last video after a bit of trial and error. This one is still not working, despite testing all the formulas in the previous comments.
Here's what I've got for formula: concat([prop("✏ 𝗫 Log"), " of "], [prop("Total Target"), " completed"])
Which yields this text: 2, of ,105, completed
Can't get rid of the commas in the final or the formula doesn't function. Any help much appreciated!
Haha - oh my - yes - I think the changes will have rather messed this up! I’m catching up too! I’ll plan a video for the series on formulas 2.0!!! Cheers. S
Subscribed! Can't wait to watch that one - your videos are a fabulous help and great pace to work along with. Thank you!@@BetterCreating