Create a HABIT TRACKER with Google Sheets! *5 MIN TUTORIAL*

In today's video, I want to share to you guys on how you can create your own habit tracker with Google Sheets! Creating it and formatting it to look clean and modern only takes 5 minutes and you are more than free to customize it however you like! This quick tutorial wastes no time and has the full functionalities of any habit tracker out there! Keep this in mind and now you can create your own habit tracker without paying for any digital asset!

Here are the formulas that I used:
(The first one is for the right bar charts, the bottom is for the bottom column charts)

=SPARKLINE(*Right Cell Count*,{"charttype","bar";"max",31;"color1","black"})
=SPARKLINE(*Bottom Cell Count*,{"charttype","column";"ymax",10;"ymin",0;"color1","black"})

--
Thank you for watching my video! Hope you enjoyed it and don’t forget to subscribe for more content like these~

Some Assets that may be used in this video:

[Engr.Hannah]

it's easy to follow, i made it under 10mins. tried changing the color from black to pink and it worked! thinking of more ways on how i'll design it. great video!

[Niroshan-nx]

Thank you very much for creating such a concise and time-saving video.

[ApdiaziizApdilaahi]

thank you, i was searching prepared ones but, after this i can make my own habit tracker

[igor_]

formula syntax depends on locale, this worked for me

[JoaMarko]

Hey Jeremy! Just came upon your channel this morning and i have already made the Budget tracker and also going to make a Habbit tracker but turning it into daily chores/responsibilities tracker rather. Liked and subscribes and i hope your channel grows with success and I am sure it will since you pump out quality content! Cheers! And thanks once more!!!

[jouaxiong]

Thank you so much for this short and straight forward tutorial video!

[maleboditshego]

Love it, will create one for myself, the bar thing is so cool

[GoingGreenMom]

Thank you, thank you, thank you for the sparkline formulas in the description!

[aravensfeather]

Just made one myself! This was super concise and helpful, thanks for the video :)

[Glitteryteddy]

This is a great tutorial, I would love if you made a mood tracker version! I'm currently converting a written mood journal into a sheet and it would be cool to see your interpretation.

[sushi]

Thank you very much for helping me make one of these. I look forward to more if you have time!

[asmaadakir]

Thank you so much very straightforward and informative

[rajnandinisingh]

Most efficient video to learn this task!
thanks for the hardwork!! <3

[janabojdova]

Very good video, thank you for helping!

[kennyjean-louis]

merci pour cette vidéo qui ma appris pas mal de chose. merci !

[kabukiarmadillo]

Short and sweet. I watched another video that took nearly an hour(!) to do the same thing.

[lucine]

You're a lifesaver, THANK YOU!! <3

[Honeyharken]

I can't get the column progress bar to work 🤔 I tried your code and the one offered by a viewer in the comments. Any ideas? I've done all the troubleshooting I can think of and haven't been able to figure it out! Thank you!

[claireantonette]

hi, this is a helpful video! I wanna know how to make it so when I'm ticking a box in sheet2 and the progress bar in sheet1 moves--if that makes sense? cause I want to make a progress summary sheet where all the progress bars are found

[LONELYKING-vp]

Funny i am comming across this now thanks so much