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:
Flaticon Icons & Logos: www.flaticon.com/

[@kennyjean-louis7737]

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

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

[@rajnandinisingh9630]

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

[@JeremysTutorials]

youre welcome!

[@asmaadakir9045]

Thank you so much very straightforward and informative

[@JeremysTutorials]

You're very welcome!

[@teddybear2454]

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!

[@ALIVE.Offical]

Great video! I appreciate it :)

[@JeremysTutorials]

youre welcome!

[@samxerox8144]

THANKS YOU MADE IT EASY

[@JeremysTutorials]

you're welcome!

[@aminadan2538]

Easy to create, fantastic

[@JeremysTutorials]

thanks! appreciate it :)

[@aleksranchinskaya9782]

Thank you for the tutorial!

[@JeremysTutorials]

gotchu 👌

[@mrigakheepatowary6609]

Hey thanks for the video it was quite helpful

[@JeremysTutorials]

Glad it helped

[@chiamakandulue5778]

Amazing!

[@JeremysTutorials]

thank you!

[@Azam_Lahore]

Thank you brother.

[@JeremysTutorials]

you're welcome!

[@yenhoang4047]

Thank you so much.

[@JeremysTutorials]

you are very welcome

[@sumanijigeesha6497]

Thanks much!!

[@JeremysTutorials]

youre welcome 😊

[@bishoy437]

Thank you very much

[@JeremysTutorials]

you're welcome!

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

[@peace.n.blessings5579]

Thank you

[@JeremysTutorials]

youre welcome!

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

[@alexandervashchuk7795]

Thanks for #value

[@JeremysTutorials]

you're welcome :)

[@chalkandsweat]

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

[@JeremysTutorials]

formula is in the description!

[@thaynagoncalves201]

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

[@JeremysTutorials]

interesting, can you give your formula?

[@agnestoding225]

me too😢

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

[@finefrensonly]

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

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

[@finefrensonly]

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

[@finefrensonly]

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