How to create your own Habit Tracker in Google Sheets - TUTORIAL + FREE TEMPLATE
Vložit
- čas přidán 20. 09. 2022
- #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).
📌 Link to FREE spreadsheet: tinyurl.com/yc888rf3
Please note: The template is sent automatically to your email (don’t forget to check your promotions folder). It should arrive within a few minutes, if it doesn’t please send an email to hello@thinklikeagirlboss.com
📌 Other FREE Tutorials: thinklikeagirlboss.com/pages/...
📌 If you would like to purchase an advanced version, you can check out the 12 MONTH HABIT TRACKER: • Habit Tracker Template...
📌 Shop Advanced Spreadsheets:
thinklikeagirlboss.com
--------------------
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"
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:
=SPARKLINE(D21;{"charttype"\"column";"ymin"\0%;"ymax"\100%;"color1"\"black"})
Hi! I'm so happy you liked it!! Thank you so much for your contribution!! I really appreciate it 😊👩🏻💻✨
you know what.. your cmt is excactly what i looking for for weeks.. i changed the formula as you did, and it worked.. Thanks so muchhhhh
p/s: Dành cho các bạn người Việt tìm đến Video này thì trong trường hợp hàm Sparkline bị lỗi Error (lỗi ko định dạng được công thức) thì hãy đổi các dấu "," trong hàm thành dấu "\",
@@viviennguyen8829 thank you so much, you saved me.
Thank you again, im from a spanish country and everything was a mess.. but this detail fix my error problem
lmao man, i just figured it out myself and then see ur comment right before i wanted to post that myself lol
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.
I'm so excited you liked it and found it useful!! Thank you so much for watching and commenting! 😊👩🏻💻✨
@@thinklikeagirlbossI loved it, thankyou so much. Can you also tell how can we add streaks count to this checklist, I didn't find a single video about this on youtube, It will help a lot, thankyou once again, great video.
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!
I'm so happy you found it useful!! Thank you so much for commenting!! 😊👩💻✨
Thank you for this detail-oriented explanation!! It helps me a LOT
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!
I'm glad it was helpful! Thank you for watching! 😊👩🏻💻✨
Omg, thank you so much! This tutorial is freaking amazing!! A lot of details and your explanations were so smooth and clear!!
I'm so happy you liked it! Thank you for watching! 😊👩💻✨
What an amazing tutorial! I'm definitely going to use the things I learned here, thank you so much!
I'm so excited to hear that!! 😊👩💻✨ Thank you so much for commenting!! I will definitely keep on making content like this 😊
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.
I'm so happy to hear you kickstarted your year with this template! I hope you like it and I hope it helps you reach your goals! Happy New Year! 😊👩🏻💻✨🎉
Thank you for this video!!! Thank you for all the formulas and the clean up part for it to look so good! I instantly subscribed!
I'm really happy you liked it!! Thank you so much for your comment!! I really appreciate it 😊👩💻✨
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
I'm so happy you liked it! Thank you so much for watching! 😊👩🏻💻✨
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.
I loved reading this! Thank you so much for watching!! 😊👩💻✨💕
I appreciate your effort, this is what I was looking for.
I'm so happy to hear that! Thank you so much for commenting!! 😊👩💻✨
This tutorial was really well explained and easy to follow. I am now happy with my tracker. Thank you!
I'm so glad you liked it! Thank you for commenting! 😊👩💻✨
This is great. Feels good to check off each task. Manageable, realistic and attainable. Thank you.
Hi! Thank you so much!! And yeah! It feels awesome to use those checkboxes 😊👩🏻💻✨
I usually don't comment on these kinds of tutorials but I loved it!! I followed through till the end of the video and enjoyed every minute of it! Thank you so much! I look forward to more tutorials from you!
Thank you SO much!! I'm so happy you liked it and decided to comment, I really appreciate it!! 😊👩🏻💻✨
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!
This was amazing to read! 💕 Thank you so much for taking the time to comment, I'm so happy you found it useful! 😊👩🏻💻✨
In case you would like to check it out this is a link to all my free tutorials thinklikeagirlboss.com/pages/free-youtube-tutorials 😊
Wow amazing tutorial! Thank you for this!! I learned so much about how advanced you can make your sheets now!
I'm so happy you liked it! Thank you for watching and commenting! 😊👩🏻💻✨
This was a very useful tutorial. Easy to follow, I learned quite a few things. Thank you!
I'm so glad to hear that! Thank you for commenting! 😊👩💻✨
Amazing step by step tutorial! I found it so helpful for 2023, thank you so much!!
I'm so happy to hear that! Thank you!! 😊👩💻✨
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.
Thank you so much!! I'm so happy you liked it!! 😊👩🏻💻✨
you're so kind for sharing this wonderful tutorial video, thank you so much!! 💖💖
Fantastic tutorial, very detailed but explained with such simplicity. Thank you
Thank you so much!! I'm really happy you liked it! 😊👩🏻💻
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.
Wow thank you so much!! I really appreciate you watching my videos and getting my products. I'm always so happy to hear that they are actually helping. Thank you for commenting! 😊👩🏻💻✨💕
Thank you for not only giving us a spreadsheet, but also explaining it to us so we can also learn the process behind it, which I find very important. I hope you have a wonderful beginning of the year 🤍
I'm so happy you found it useful!! Thank you so much for your comment I loved it!! 😊👩💻✨
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!!
I'm so happy to hear this! Thank you!! If you learn a little bit at a time I'm sure you will master it in no time 😊👩🏻💻✨
this is the best habit tracker tutorial i ever watch, and also the way u explaining the function really helping me, thank you so much
Thank you so much for watching! I'm so happy to read you liked it! 😊👩💻✨
Thank you so much for your expert guidance through the complicated coding needed to make this tracker. I have followed along, made my own, and duplicated the sheet to make one for next month. Amazing.
I'm so glad you liked it!! Thank you for watching and commenting! 😊👩🏻💻✨
Thank you for walking us through this whole process. You are so helpful!
I'm so happy it helped you!! Thank you for watching and commenting! 😊👩💻✨
Thank you so much, Sis for this amazing tutorial. Its help me to recognize my habit for next year. Thank you
This tutorial is so helpful! If you're still taking video requests, I would love to learn how to make the auto-populated grocery list :) thanks again for your work!
Hi! Thank you so much for commenting! That's actually already on my list!! I'm trying to get better at making them faster so I hope I can come up with more tutorials soon 😊👩🏻💻✨
This is a really great tutorial, thanks! Gonna try and make a reading spreadsheet myself
Thank you so much!! And that's amazing!! Please keep me posted on how that works out! 😊👩🏻💻✨
Thank you so much! I loved the tutorial!
I came across this randomly, but it's so good! Thank you very much :D
Thank you so much for watching!! 😊👩🏻💻✨
You teach really well. Thank you :)
Thank you so so much, you are so awesome for giving us such useful information and being so detailed. You’ve helped me so much!
Thank you so much for your video, This is what I was lookin for
Thank you for this tutorial. Really learnt a lot with this. The more you know :)
So grateful to you for making videos like this. You're helping so many people.
It's really nice of you to say this! Thank you so much! I'm glad you found it useful 😊👩💻✨
thank you for helping us! this is worth it than any apps I tried before@@thinklikeagirlboss
Thank you so much! Such an amazing video!
Mk te amo, es el mejor tutorial que he visto. Le pusiste mucho empeño, gracias por eso!❤😘🥰
Muchísimas gracias!! 😊👩🏻💻✨💕
Such a good tutorial! I could follow it perfectly.
I'm so happy to hear that!! Thank you for watching and commenting! 😊👩🏻💻✨
Thank you for this! Very informative!!! 🎉❤
This was amazing! Thank you so much for this tutorial you are a great teacher! I want to track weekly and then have it also add the monthly percentages, I'm gonna see if I can do ii!!!
Hi! Thank you so much!! That's so sweet of you to say!! Let me know how it goes with the things you'll be adding to it!! 😊👩💻✨
@@thinklikeagirlboss ummm no, I said this before I saw your other videos and your etsy store LOL! I'm just gonna purchase them and save myself a headache! Appreciate all your hard work!
I'm so happy you also liked the shop!! Thank you so much!! 😊👩💻✨
Thank you so much for this video! It was really useful
🥰 How useful!! I love u ❤️ thanks for sharing the tutorial and the spreadsheets
Hi!! Thank you so much for watching and commenting!! I really appreciate it!! 😊👩💻✨
This is so dope and amazing; thank you so much
This was a wonderful tutorial. Thank you so much!
I'm so happy you liked it! Thank you for watching! 😊👩🏻💻✨
I agree with most of these comments. This tutorial was very well done! I'm excited to create a tracker for the new year (:
Thank you so much!!! I'm so happy to hear that!! 😊👩💻✨
Thank you so much, it is really informative and well explained ❤
This was very helpful. Thank you
Powerful lesson!
Thank you a lot to sharing decent experience!
I tried different applications for tracking habits. But, personally for me this habit tracker is most efficient - you have plain overall view on all of your habits. And Google Sheet is every time available for free )
And you have a nice voice )
Hi! You're so sweet! Thank you so much for taking the time to watch and comment!! I'm really happy you found it useful 😊👩🏻💻✨
@@thinklikeagirlbossI loved it, thankyou so much. Can you also tell how can we add streaks count to this checklist, I didn't find a single video about this on youtube, It will help a lot, thankyou once again, great video.
Great and simple tutorial. I am gonna create one for my own. Thanks a ton.
I'm so glad you liked it! Thank you!! 😊👩💻✨
WOW! This was a phenomenal video. Please keep them coming!
Thank you so much!!!!! ✨ I definitely will!! 😊 Any requests that I can add to my list? 👩💻
@@thinklikeagirlboss would you do a mood tracker, please? and if possible, could it have like a graph or something visual with colors to see how many days you have been in x mood easily. if it inst possible thank you anyway :)
Hi again! I just realized I skipped this message I'm sorry! I would love to!! I will add it to my list 😊👩💻✨
Thank you so so much. This was so great and easy to understand.
I'm so happy you liked it!! Thank you for watching and commenting! 😊👩💻✨
wow this is interesting! im gonna try making on my own, thank you so much for the tutorial :) very helpful!
I'm glad you found it helpful!! Thank you so much for watching! 😊👩💻✨
Thanks a lot! for this awesome explanation, it's going to help me in various ways.
Thank you so much! I followed along and kept pausing at each step to get my tracker set up. Worked out great!
I'm so happy you followed along! Thank you so much for watching and commenting! 😊👩💻✨
thank you so much it really help me as a student may god bless you
i LOVED this tutorial, thank youuuuu!!
I'm so glad!! Thank you for commenting!! 😊👩💻✨
This is really what I need ❤ thankyou so much, sending love from Indonesia ❤❤
I'm so glad it was what you needed!! 😊👩💻✨💕
This is so useful, you are a very good teacher. Thanks❤
Thank you so much!! 😊👩🏻💻✨💕
AWESOME AWESOME TUTORIAL. THANK YOU SO MUCH. GREAT INSTRUCTIONS!!!
Thank you!! 😊👩💻✨
New user, thank you so much. Looking forward to learning more :)
Hi! Thank you for watching! If you would like to check out the rest of my free tutorials you can find them linked here: thinklikeagirlboss.com/pages/free-youtube-tutorials 😊👩💻✨
Thank you so much for the wonderful tutorial!
I'm so happy you liked it! Thank you so much for watching! 😊👩🏻💻✨
This is a great template, cheers 👍🏻
I would love to have seen conditional formatting on the Charts (25% = red, 50%= orange, 75% = green)
This is a great start for tracking 'right now', or one you could add additional months to, but next level would be
- for dates to 'store' the information (checkboxes) so that you get cumulative results (e.g. month chart, year chart, year on year.)
- countif function for individual days, months etc, to see if (for example) Saturdays are a bad day for all habits, or Mondays are bad for habit 3.
thanks for a thorough tutorial.
Cool. Thanks much for this tutorial.👍🏼👍🏼
Thank you so much. I learned a ton, very helpful
I'm so happy to hear that! Thank you for watching! 😊👩🏻💻✨
Girlie why are you so good i mean why do you do this for the world are you an angel god sent omg
You're so sweet, thank you!! 😊👩🏻💻✨💕
I had waaaaay too much fun following this along!!!!
I'm so happy you found it fun!! Thank you for watching! 😊👩💻✨
i have applied this sheet, thank you very much
Hi!! Great video and very helpful as well. I loved your detailed explanation. Congrats.
Thank you so much!! 😊👩💻✨
Wonderful! You are remarkably good at this. Your chanel deserves more subscribes. Thanks for sharing us this super useful havbit tracker template.
Thank you so much for your comment!! I hope I can keep on creating content you enjoy 😊👩💻✨💕
Thank you so much i really need this in my life .
I'm so happy you found it useful! 😊👩🏻💻✨
Thank you, that was amazing, and very well explained, it's interesting 👍
Thank you so much!! 😊👩💻✨
Thank you very much! You covered a lot here
Thank you so much for commenting!! I hope it helps you!! 😊👩💻✨
Awesome tutorial. Thank you so much :)
Thank you for watching!! 😊👩🏻💻✨
Thank you! very much very well explained :)
Thank you for watching! 😊👩💻✨
this is AMAZING. thank you so so much.
Very helpful Video !
Very nice tutorial, I start learning google sheet with this amazing channel. Thank you very much
I'm so happy to hear that! Thank you for watching! 😊👩🏻💻✨
AMAZING!
An amazing tutorial - thank you!
Thank you so much!! 😊👩🏻💻✨
Thank you so much!!!
I never thought that I could learn so much from a single youtube video
I'm so happy to hear that!! Thank you so much for commenting 😊👩🏻💻✨
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
Wow!! Thank you SO much for letting me know. I've wanted to do this types of videos for a long time but was scared I wouldn't do a good job, so I kept putting it off. I'm really glad you found it useful! Reading this makes me excited to keep making more 😊👩🏻💻 Thank you!!
@@thinklikeagirlboss Yah,, your tutorial is GREAT!! Here's what I've done by following your instruction: docs.google.com/spreadsheets/d/1aT6iabDJJaQq0uPslqLaQuBvWCY5RX1l9RpSSLiy11g/edit?usp=sharing
I just looked at it!! You have no idea how happy this makes me! Thank you so much for sharing it, this is exactly what I wanted, people using it as a base to create something completely original. 😊 Thank you so so much for showing this to me 😊👩🏻💻
Love this~
Great content!
Very very helpful. Thank you
Thank you so much for this! :)
Thank you for watching! 😊👩💻✨
Excatly what I was looking for!!!!!
I'm glad you found it useful!! 😊👩💻✨
thanks , very helpful
This was excellent. Thank you very much for sharing.
Thank so you much for watching! I'm glad you liked it 😊👩🏻💻✨
Thank you so much, love from the Philippines.
Thanks a lot awesome tutorial.
This is amazing ,thank you so much!!!
Thank you for watching!! 😊👩💻✨
This is amazing I wish I had found this while I was still in school!
I'm so happy you liked it! Thank you for commenting 😊👩🏻💻✨
So happy I found this! I usually buy my complex spreadsheets but I do like the satisfaction of making one (sad life haha) Only part I got stuck on was the progress bars, I give up. Only had a full black cell. Thanks so much for the tutorial.
Hi! Don't give up! Can you select that black cell and use the paint bucket to change the background color to white? And see if that fixes it? 😊👩💻✨
@@thinklikeagirlboss I wish I had but I have gone past there & now don’t know how to go back & fit in. I’m still pretty happy with it.
Thanks so much for the tutorial and free template
Thank you for watching and commenting!! 😊👩💻✨
Great tutorial, thank you so much!
Thank you for watching!! 😊👩💻✨
this's so helpful, thanks you so much !!❤❤❤❤
I'm so happy you found it helpful!! Thank you for watching!! 😊👩💻✨💕