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

  • @jouaxiong4368
    @jouaxiong43688 күн бұрын

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

  • @kennyjean-louis7737
    @kennyjean-louis7737Ай бұрын

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

  • @sushi13141
    @sushi131414 ай бұрын

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

  • @JeremysTutorials

    @JeremysTutorials

    4 ай бұрын

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

  • @Niroshan-n7x
    @Niroshan-n7x23 күн бұрын

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

  • @JeremysTutorials

    @JeremysTutorials

    21 күн бұрын

    You're welcome!

  • @rajnandinisingh9630
    @rajnandinisingh96306 ай бұрын

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

  • @JeremysTutorials

    @JeremysTutorials

    6 ай бұрын

    youre welcome!

  • @asmaadakir9045
    @asmaadakir9045Ай бұрын

    Thank you so much very straightforward and informative

  • @JeremysTutorials

    @JeremysTutorials

    Ай бұрын

    You're very welcome!

  • @tuanphong271
    @tuanphong2716 күн бұрын

    Thanks for the tutorial

  • @aleksranchinskaya9782
    @aleksranchinskaya9782Ай бұрын

    Thank you for the tutorial!

  • @JeremysTutorials

    @JeremysTutorials

    27 күн бұрын

    gotchu 👌

  • @Glitteryteddy
    @Glitteryteddy6 ай бұрын

    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

    @JeremysTutorials

    6 ай бұрын

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

  • @ALIVE.Offical
    @ALIVE.Offical5 ай бұрын

    Great video! I appreciate it :)

  • @JeremysTutorials

    @JeremysTutorials

    5 ай бұрын

    youre welcome!

  • @aminadan2538
    @aminadan25385 ай бұрын

    Easy to create, fantastic

  • @JeremysTutorials

    @JeremysTutorials

    5 ай бұрын

    thanks! appreciate it :)

  • @victorjourney
    @victorjourney3 ай бұрын

    THANKS YOU MADE IT EASY

  • @JeremysTutorials

    @JeremysTutorials

    3 ай бұрын

    you're welcome!

  • @chiamakandulue5778
    @chiamakandulue57787 ай бұрын

    Amazing!

  • @JeremysTutorials

    @JeremysTutorials

    7 ай бұрын

    thank you!

  • @Azam_Lahore
    @Azam_Lahore5 ай бұрын

    Thank you brother.

  • @JeremysTutorials

    @JeremysTutorials

    5 ай бұрын

    you're welcome!

  • @MaloneVS
    @MaloneVS8 күн бұрын

    thanks my boy

  • @mrigakheepatowary6609
    @mrigakheepatowary66092 ай бұрын

    Hey thanks for the video it was quite helpful

  • @JeremysTutorials

    @JeremysTutorials

    2 ай бұрын

    Glad it helped

  • @yenhoang4047
    @yenhoang40472 ай бұрын

    Thank you so much.

  • @JeremysTutorials

    @JeremysTutorials

    2 ай бұрын

    you are very welcome

  • @sumanijigeesha6497
    @sumanijigeesha64973 ай бұрын

    Thanks much!!

  • @JeremysTutorials

    @JeremysTutorials

    3 ай бұрын

    youre welcome 😊

  • @bishoy437
    @bishoy437Ай бұрын

    Thank you very much

  • @JeremysTutorials

    @JeremysTutorials

    Ай бұрын

    you're welcome!

  • @peace.n.blessings5579
    @peace.n.blessings55795 ай бұрын

    Thank you

  • @JeremysTutorials

    @JeremysTutorials

    5 ай бұрын

    youre welcome!

  • @MA-dd9dd
    @MA-dd9dd12 күн бұрын

    wow wow wow

  • @JeremysTutorials

    @JeremysTutorials

    10 күн бұрын

    thanks :D

  • @alexandervashchuk7795
    @alexandervashchuk77956 ай бұрын

    Thanks for #value

  • @JeremysTutorials

    @JeremysTutorials

    6 ай бұрын

    you're welcome :)

  • @claireantonette5523
    @claireantonette55232 ай бұрын

    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

    @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

  • @AnnRukutana
    @AnnRukutana2 ай бұрын

    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

    @JeremysTutorials

    Ай бұрын

    can I see your formula?

  • @chalkandsweat
    @chalkandsweat3 ай бұрын

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

  • @JeremysTutorials

    @JeremysTutorials

    2 ай бұрын

    formula is in the description!

  • @thaynagoncalves201
    @thaynagoncalves201Ай бұрын

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

  • @JeremysTutorials

    @JeremysTutorials

    Ай бұрын

    interesting, can you give your formula?

  • @agnestoding225

    @agnestoding225

    26 күн бұрын

    me too😢

  • @feliperojas7838

    @feliperojas7838

    23 күн бұрын

    you can try using ; instead of ,

  • @moesart7059
    @moesart705910 күн бұрын

    Can't you share it?

  • @JeremysTutorials

    @JeremysTutorials

    10 күн бұрын

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

  • @lucassantanadeoliveira8824
    @lucassantanadeoliveira88246 ай бұрын

    Hi, those formulas didn't work here 😐

  • @JeremysTutorials

    @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

    @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

    @JeremysTutorials

    6 ай бұрын

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

  • @audaciouslygi

    @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

    @audaciouslygi

    6 ай бұрын

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

Келесі