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

[@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-n7x]

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

[@JeremysTutorials]

You're welcome!

[@ApdiaziizApdilaahi]

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

[@JeremysTutorials]

sounds good :)

[@igor_242]

formula syntax depends on locale, this worked for me
=SPARKLINE(AI6;{"charttype"\"bar";"max"\31;"color1"\"black"})
=SPARKLINE(D14;{"charttype"\"column";"ymax"\10;"ymin"\0;"color"\"black"})

[@maleboditshego]

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

[@JeremysTutorials]

agreed!

[@jouaxiong4368]

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

[@JeremysTutorials]

appreciate it

[@GoingGreenMom]

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

[@JeremysTutorials]

youre welcome!

[@MonisKhan-fs1ku]

thanks soooooooooooo much, its so awesome............!!! , so helpful. thanks

[@JeremysTutorials]

Glad it helped!

[@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!!!

[@JeremysTutorials]

appreciate your kind words!

[@aravensfeather2874]

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

[@JeremysTutorials]

no worries! glad you found it helpful!

[@LONELYKING-v1p]

Funny i am comming across this now thanks so much

[@asmaadakir9045]

Thank you so much very straightforward and informative

[@JeremysTutorials]

You're very welcome!

[@kennyjean-louis7737]

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

[@lucine6594]

You're a lifesaver, THANK YOU!!

[@JeremysTutorials]

no YOU!

[@janabojdova5450]

Very good video, thank you for helping!

[@JeremysTutorials]

thank you for watching!

[@rajnandinisingh9630]

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

[@JeremysTutorials]

youre welcome!

[@H2O5519]

THANK YOU!!!!!!

[@kabukiarmadillo]

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

[@JeremysTutorials]

appreciate it! saved you an hour :)

[@aleksranchinskaya9782]

Thank you for the tutorial!

[@JeremysTutorials]

gotchu 👌

[@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.

[@JeremysTutorials]

that's a great idea I'll keep that in mind!

[@ajiwibowo238]

Thank you bro

[@JeremysTutorials]

thank you!

[@sushi13141]

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

[@JeremysTutorials]

thanks for watching! of course, will make more in the future!

[@victorjourney]

THANKS YOU MADE IT EASY

[@JeremysTutorials]

you're welcome!

[@tuanphong271]

Thanks for the tutorial

[@JeremysTutorials]

no worries :D

[@mrigakheepatowary6609]

Hey thanks for the video it was quite helpful

[@JeremysTutorials]

Glad it helped

[@Azam_Lahore]

Thank you brother.

[@JeremysTutorials]

you're welcome!

[@aminadan2538]

Easy to create, fantastic

[@JeremysTutorials]

thanks! appreciate it :)

[@dianeka6363]

thank you

[@ALIVE.Offical]

Great video! I appreciate it :)

[@JeremysTutorials]

youre welcome!

[@yenhoang4047]

Thank you so much.

[@JeremysTutorials]

you are very welcome

[@bishoy437]

Thank you very much

[@JeremysTutorials]

you're welcome!

[@sumanijigeesha6497]

Thanks much!!

[@JeremysTutorials]

youre welcome 😊

[@Aaliya-fu5fo]

Heyy but i can't find the Check boxes anywhere.. wht to do?

[@ridwanahmed7779]

select the cells you want to place the check box, then click insert, then checkbox

[@JeremysTutorials]

agreed! try this

[@chiamakandulue5778]

Amazing!

[@JeremysTutorials]

thank you!

[@MaloneVS]

thanks my boy

[@JeremysTutorials]

gotchu

[@AnnRukutana]

Hey, thank you so much I the video, I did it and everything worked except for the Sparkline. It keeps saying sparkline requires more data points so I’m stuck there

[@JeremysTutorials]

can I see your formula?

[@MA-dd9dd]

wow wow wow

[@JeremysTutorials]

thanks :D

[@capitalizein5616]

Please teach the rest of the youtubers how to make videos !!!!!😁

[@JeremysTutorials]

haha we'll see about that ;)

[@vaishalinbaria1339]

HOW TO LINK THE CHECKBOXES TO THE DATE SELECTED ABOVE???? IF I CHANGE THE DATE THE CHECKBOXES DOESN'T CHANGE......

[@JeremysTutorials]

what do you mean?

[@claireantonette5523]

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

[@JeremysTutorials]

no problem! when you're referencing a cell in a different sheet, try doing it like this "=Sheet2!A1", so in Sheet 1, you can refer to Sheet2 data like that

[@jaihari8616]

The sparkline thing is not working for me i g

[@thaynagoncalves201]

when i write TRUE just shows an error, i am so frustrated

[@JeremysTutorials]

interesting, can you give your formula?

[@agnestoding225]

me too😢

[@feliperojas7838]

you can try using ; instead of ,

[@ashik6419]

hey ther bottom progress bar is not working.. what should i do?

[@JeremysTutorials]

let me see your formula

[@ashik6419]

@@JeremysTutorials actually it worked
The thing is
I changed color1 to color
And it worked
Thanks for the reply..

[@alexandervashchuk7795]

Thanks for #value

[@JeremysTutorials]

you're welcome :)

[@sourabhdehariya6320]

Could you please provide this pdf by any chance 😅

[@JeremysTutorials]

it won't work with PDF on an interactable format :(

[@chalkandsweat]

sorry, not very firm with this stuff. great video though! whats the formula for the counter? thx

[@JeremysTutorials]

formula is in the description!

[@lucassantanadeoliveira8824]

Hi, those formulas didn't work here 😐

[@JeremysTutorials]

they work for me.. hmm did you try adjusting it accordingly and changing the arbitrary values to the cell numbers? (change where I put * Right Cell Count * to your cell accordingly, without asterisks). dont forget the = sign as well

[@audaciouslygi]

@@JeremysTutorialsIm having the same issue with the formulas not working. I edited the cell and have the equal sign as well yet I keep getting this error message SPARKLINE requires more data points. Expected: 1, found: 0.

[@JeremysTutorials]

@@audaciouslygi can you type in your exact formula here?

[@audaciouslygi]

@@JeremysTutorials sure the right one is =SPARKLINE(AG5,{"charttype","bar";"max",30;"color1","black"}) and the bottom is =SPARKLINE(B22,{"charttype","column";"ymax",10;"ymin",0;"color1","black"})

[@audaciouslygi]

@@JeremysTutorialsThank you so much for your speedy reply :)

[@moesart7059]

Can't you share it?

[@JeremysTutorials]

I can but that would defeat the purpose of the tutorial :)

[@capitalizein5616]

Superb & efficeint expalanition ! 🤯

[@JeremysTutorials]

appreciate it!

[@ZaettiCraft]

Thanks for the tutorial

[@JeremysTutorials]

no probs!

[@peace.n.blessings5579]

Thank you

[@JeremysTutorials]

youre welcome!