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/
Пікірлер: 64
Thank you so much for this short and straight forward tutorial video!
merci pour cette vidéo qui ma appris pas mal de chose. merci !
Thank you very much for helping me make one of these. I look forward to more if you have time!
@JeremysTutorials
4 ай бұрын
thanks for watching! of course, will make more in the future!
Thank you very much for creating such a concise and time-saving video.
@JeremysTutorials
21 күн бұрын
You're welcome!
Most efficient video to learn this task! thanks for the hardwork!!
@JeremysTutorials
6 ай бұрын
youre welcome!
Thank you so much very straightforward and informative
@JeremysTutorials
Ай бұрын
You're very welcome!
Thanks for the tutorial
Thank you for the tutorial!
@JeremysTutorials
27 күн бұрын
gotchu 👌
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
6 ай бұрын
that's a great idea I'll keep that in mind!
Great video! I appreciate it :)
@JeremysTutorials
5 ай бұрын
youre welcome!
Easy to create, fantastic
@JeremysTutorials
5 ай бұрын
thanks! appreciate it :)
THANKS YOU MADE IT EASY
@JeremysTutorials
3 ай бұрын
you're welcome!
Amazing!
@JeremysTutorials
7 ай бұрын
thank you!
Thank you brother.
@JeremysTutorials
5 ай бұрын
you're welcome!
thanks my boy
Hey thanks for the video it was quite helpful
@JeremysTutorials
2 ай бұрын
Glad it helped
Thank you so much.
@JeremysTutorials
2 ай бұрын
you are very welcome
Thanks much!!
@JeremysTutorials
3 ай бұрын
youre welcome 😊
Thank you very much
@JeremysTutorials
Ай бұрын
you're welcome!
Thank you
@JeremysTutorials
5 ай бұрын
youre welcome!
wow wow wow
@JeremysTutorials
10 күн бұрын
thanks :D
Thanks for #value
@JeremysTutorials
6 ай бұрын
you're welcome :)
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
2 ай бұрын
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
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?
sorry, not very firm with this stuff. great video though! whats the formula for the counter? thx
@JeremysTutorials
2 ай бұрын
formula is in the description!
when i write TRUE just shows an error, i am so frustrated
@JeremysTutorials
Ай бұрын
interesting, can you give your formula?
@agnestoding225
26 күн бұрын
me too😢
@feliperojas7838
23 күн бұрын
you can try using ; instead of ,
Can't you share it?
@JeremysTutorials
10 күн бұрын
I can but that would defeat the purpose of the tutorial :)
Hi, those formulas didn't work here 😐
@JeremysTutorials
6 ай бұрын
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
6 ай бұрын
@@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
6 ай бұрын
@@audaciouslygi can you type in your exact formula here?
@audaciouslygi
6 ай бұрын
@@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
6 ай бұрын
@@JeremysTutorialsThank you so much for your speedy reply :)