Aesthetic Notion Views That WORK. Notion Habit Tracker Build with Formulas!

In this Notion Habit Tracker build I'll show you how to create aesthetic Notion views that actually work as powerful reports. 🔔 Prompted Notion Goals Template offer BELOW + Sign up to my Notion From Scratch email list & learn Notion fundamentals as you go! ➜ www.bettercreating.com/notion...
NOTION FORMULAS 2.0: Notion updated their formulas: I have added the new versions you need for this build in my pinned comment! Please note: you need to match to your referenced property names such as my property being called '✎✘ Log'.
This Notion training series will help you build A complete Notion setup through step-by-step build tutorials so you can master Notion fundamentals from - databases to formulas, and join the digital second brain revolution!
🔔 Get My Prompted Goal Setting & Yearly Review Template: The 1st 100 people get 50% off: Download on Gumroad HERE: tinyurl.com/42xv7528 (Just follow the tutorial & integrate it into this build! Thanks for supporting me to make these videos 😊)
🖥️ Download My Notion Templates: bettercreating.com/downloads
🎬 WATCH NEXT:
Notion From Scratch Video 3: The Ultimate Habit Tracker Build! • The Ultimate Notion Ta...
Should You Be Using Notion To Organise Your Life? Your Second Brain Q&A: • Should You Be Using No...
📖 Read Tiny Habits by B J Fogg: US: www.amazon.com/dp/B07LC9KDP5/... UK | www.amazon.com/dp/B07LC9KDP5/...
➜ FOLLOW ME / DOWNLOADS:
📨 Sign up to my occasional newsletter on productivity, Notion & lifestyle design: bettercreating.com
📸 Instagram - / bettercreating
🐦 Twitter - / bettercreating1
🌍 www.bettercreating.com
🎬 VIDEO CHAPTERS:
00:00 Habit Tracker in Notion From Scratch: The Big Build Along Part 2!
01:04 New Notion Course: My Notion From Scratch Training Series
01:39 Notion Habit Tracker Build Part 1 Recap
02:01 Habit Status Report: How To Use Concat Formulas In Notion
04:01 Using If Statements In Notion: Creating The Multi-Option Report View
05:31 Creating A Last Logged Habit Report View in Notion
07:31 Creating A Home Page Dashboard: Using Linked Database Views In Notion
08:45 How To Use Relations In Notion: Linking Goals & Habits Databases.
💻 MY FAVOURITE TOOLS:
Notion: affiliate.notion.so/bettercre...
Shortform: shortform.com/bettercreating
Orbitkey Desk Gear & EDC: (BETTER10 for 10%) www.orbitkey.com/?rfsn=684926...
BETTER CREATING
My name is Simon, and I'm finding ways to simplify productivity & creative life.
Exploring productivity, simple living and creative life, the Better Creating KZbin Channel is my project to build a toolkit to help creative people (including me) create more meaningful work, create better content, and live more intentional stress-free lives in the process. Other than doing this, I work as a freelance creative in theatre and film, creating productions.
#Notion #HabitTracker #BetterCreating
--

[@BetterCreating]

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"))

[@MichaelKovalev-hs5zm]

4:00 my new version is concat([prop("Log") + " of " + prop("Total Target") + " completed"])

[@brandstrength]

Thank you! This was about to do me in!

[@BetterCreating]

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!

[@karolinapartyka6013]

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!

[@djthompson1971]

Ga!! Thank you !!! I was feeling defeated but this worked!!

[@mogta7d]

Thanks mike Iam so glade for you

[@haskhan]

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 "

[@BetterCreating]

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 :)

[@haskhan]

and "Last Logged " + formatDate(prop("Last Updated"),"DD MMMM") for Last Logged

[@watchlearn1167]

Excellent comment, thx

[@brendanbos4235]

this was helpful. Thanks!

[@tomtrlz7784]

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

[@DigbyLewis1]

Spent ages trying to work out what I was doing wrong, then checked the comments. Doh! Thanks everyone who posted the current method. 👍

[@jessicaa7766]

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 :)

[@BetterCreating]

Ah thanks so much! Great stuff!

[@tishbouvier]

You are one of the best Notion teacher on KZbin. You make each step, including the formulas easy to implement. Thank YOU!!!

[@BrendanPatrickGrace]

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.

[@serena5595]

Cant thank you enough for this comment!!

[@BetterCreating]

Thanks! Great update comment! Good spot.

[@jesusvives2149]

This was getting headache to me haha thanks a lot!

[@kavineesh12]

Can't thank you enough

[@mikecorbean9985]

Brenda rules!!

[@kogarashiii3973]

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.

[@eatingplantmagic2471]

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! 😁)

[@BetterCreating]

Wonderful! Welcome to the channel - spread the word!

[@rebeccafoxstoddard]

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. :)

[@BetterCreating]

Great to hear - thanks for watching and great to have you. Please spread the word ! :)

[@KylerStocks]

Building out my dream planner becuase of you! Thank you!

[@BetterCreating]

Great stuff! Welcome to the club! Make sure you are on the mailing list for occasional updates on build videos too :)

[@agentdisast3r]

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.

[@christoviljoen1]

You are a brilliant teacher!

[@24dshell]

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 KZbin. 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. 😊😊

[@BetterCreating]

Love this! Thanks so much for the feedback: makes it all worth it! Goal Setting build is coming out in a few weeks too :)

[@jesusvives2149]

I know this will help me a lot, I needed it! Thanks a lot!

[@BetterCreating]

Glad to hear that! Welcome to the channel!

[@AlexandruGheorghiuP]

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

[@thechristhetics]

Love you man! Really helped me a lot! You're the best!

[@BetterCreating]

Glad I could help!

[@calvinpough994]

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?

[@nyem6866]

woooow you take it to a new level

[@BetterCreating]

Thanks my friend - It's been a fun journey!

[@joaquinginer6020]

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

[@BetterCreating]

I’m thinking of getting into some student and study stuff in 2023 - thanks for the suggestion :)

[@joaquinginer6020]

@@BetterCreating great

[@saskianieuwland5965]

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?

[@leiselclayton5772]

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).

[@saskianieuwland5965]

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?

[@mphomuila9460]

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

[@sqs2561zz]

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!

[@BetterCreating]

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!

[@mojabaabed5189]

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

[@BetterCreating]

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 👍

[@HDSportsterdubai]

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.

[@BetterCreating]

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. :)

[@BrendanPatrickGrace]

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 ")

[@TheCosmicSeer]

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 !

[@oliviawebber2206]

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!

[@SaleemHodge]

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

[@viralarmytv7932]

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 ")

[@kellysharpe2122]

Maybe add a comma after the second quote mark (before the first "format").

[@vcalodabe]

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

[@JasonMvrtinez]

what do you push while writing formula to insert emoji?

[@BetterCreating]

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. :)

[@anthonysanmiguel]

Can anyone help with the concat formula with the 2.0 update? Nothing seems to work for me

[@BetterCreating]

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. :)

[@nataliedavison5592]

Any Help on the Last Logged formula. It's not working for me.

[@nataliedavison5592]

Sorry, I just saw this in your description box with your new formulas. (" Last Logged: " + formatDate( Last Updated, "DD MMMM"))

[@steveg0831]

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

[@safiyyahajayi8985]

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")

[@SSS-tf2mz]

How to manage time as School student running a business and getting good grades

[@Mshmoylova]

"... 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?)

[@dmendex]

This video needs updatinf

[@wordpictureink]

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!

[@BetterCreating]

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

[@wordpictureink]

Subscribed! Can't wait to watch that one - your videos are a fabulous help and great pace to work along with. Thank you!@@BetterCreating