How to create your own Habit Tracker in Google Sheets - TUTORIAL + FREE TEMPLATE

#habittracker #googlesheets #tutorial

Some of you have been asking for Google Sheets Tutorials so I decided to start with a Habit Tracker. I tried to create it in a way that, at the same time I was showing you how to build it, I was also showing you a few tricks and formulas. So that's why it's such a long video. I hope you find it useful.

If you are already familiar with Google Sheets and don't want all the details you can change the video settings and make it play faster (2x).

📌 Shop Advanced Spreadsheets:

--------------------

Formulas I mentioned (to copy and paste):

- Horizontal progress bar:
=SPARKLINE(5,{"charttype","bar";"max",10;"color1","black"})

- Vertical progress bar:
=SPARKLINE(50%,{"charttype","column";"ymin",0%;"ymax",100%;"color","black"})

- Conditional formatting: Apparently angled brackets aren't allowed in the description so I couldn't complete the formula. Please pause the video and copy the formula manually.

HEX values I used:
"#d4c0c6"
"#726c8e"
"#544f6a"

[bloomtagsp.zo.o.]

Hi! What a wonderful tutorial! Thank you so much. In case anyone else struggles with it, in some European countries, where commas are used as decimal separators, you need to change commas into backslash, so it looks as so:

[gh-pses]

I'm not very good at things like Google sheets or power point where there are a lot of tiny options that don't feel intuitive to me and with which I don't know what to do or how to utilise. Following this tutorial and achieving this spreadsheet truly did make me feel like a girl boss! Thank you!!

[jenniferlugo]

This was the BEST walkthrough ever. Not only did you give us instructions but you also gave us a few quick lessons that makes this customizable enough to fit my needs. I didn't know much at all before doing this and it was so easy that I feel comfortable enough to go through and make the other sheets you offer. You're amazing and this is awesome. <3

[raniali]

i am so thankful for this video i almost lost hope on finding a tutorial FOR BEGGINERS untill i found yours thank u so much please keep on sharing more of these best of luck

[ArslanAhmed]

Happy New Year, everyone! 🎉 Just wanted to share that I've kickstarted my year by setting up this awesome goal chart on Google Sheets! 🚀✨ It's a fantastic way to visualize and track my goals throughout the year. Big shoutout to the video that guided me through the process! 🙌 May this year bring success, growth, and joy to each one of us.

[nishaCart]

I think this tutorial was awesome!!! 10/10 I really thought it was going to be extremely difficult, but you broke it down so well. Plus, I had fun learning! Thank you so much!

[megauravrajput]

Ma'am thanks 🙏👍 for your kind help, respect 🙏☺️ from india❤

[QuỳnhTrịnhNhư-ie]

Thank you a lot. I have a lot of ideas, but I don't know how to create them. I saw many YouTube channels selling templates, but I don't have enough money. This video truly helped me a lot.

[helenayustika]

Thank you for this detail-oriented explanation!! It helps me a LOT

[adilenejezabelmoreno]

you've helped me create something I've been trying to do for years. you also taught me more about excel than any course and i'm a grad student. thank you so much. Please make more content like this!

[huuduyentranthi]

Omg, thank you so much! This tutorial is freaking amazing!! A lot of details and your explanations were so smooth and clear!!

[Akki_]

Thank you so much. I watched so many tutorials on how to do this. But this is the best I have come across. The way you explained every step in detail along with alternatives, its just amazing. Thank You!!!!

[PeterDeveros]

I searched everywhere for something like that and finally I found exactly something like this that too for free, thank you so much

[emphaticme]

I appreciate your effort, this is what I was looking for.

[makaylanguyen]

Amazing step by step tutorial! I found it so helpful for 2023, thank you so much!!

[ajmedinaeth]

Oh my god I've been looking for you all day and didn't realize it until now. Thanks for putting this together. I love you.

[whims_of_niv]

I am so so thankful for your video! You explain things so easily, I absolutely loved working alongside this video of yours! Please keep on doing what you do! And a happy new year to you!

[quietstorm]

My nerdy side is kicking in. I think I love using the formulas too much, I've been coming back to your videos to learn more lol. Btw, I also purchased your monthly planner and I'm loving it!! I love how I can track where my hours are going.

[donterrencerollon]

Hey, Thank you so much for this tutorial.. I'm able to apply it on my Habits tracker too... And this is my first time doing it, , since I am not good at spreadsheets, , but when I follow your tutorial... It was so easy, , This is one of my limiting beliefs since 2015 and I am able to do it.. . Looking for more tutorial
s, , Thank you so much

[everydayvdo]

i have been taking therapy and didn't know how to make a habit tracker. you explained it simply. keep up the good work. amazing video. thank you.