Тёмный

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

Jeremy's Tutorials
Подписаться 10 тыс.
Просмотров 20 тыс.
50% 1

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/

Хобби

Опубликовано:

 

30 ноя 2023

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 59   
@Niroshan-n7x
@Niroshan-n7x 12 дней назад
Thank you very much for creating such a concise and time-saving video.
@JeremysTutorials
@JeremysTutorials 10 дней назад
You're welcome!
@kennyjean-louis7737
@kennyjean-louis7737 Месяц назад
merci pour cette vidéo qui ma appris pas mal de chose. merci !
@rajnandinisingh9630
@rajnandinisingh9630 6 месяцев назад
Most efficient video to learn this task! thanks for the hardwork!!
@JeremysTutorials
@JeremysTutorials 6 месяцев назад
youre welcome!
@sushi13141
@sushi13141 4 месяца назад
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!
@asmaadakir9045
@asmaadakir9045 Месяц назад
Thank you so much very straightforward and informative
@JeremysTutorials
@JeremysTutorials Месяц назад
You're very welcome!
@teddybear2454
@teddybear2454 5 месяцев назад
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 5 месяцев назад
that's a great idea I'll keep that in mind!
@ALIVE.Offical
@ALIVE.Offical 5 месяцев назад
Great video! I appreciate it :)
@JeremysTutorials
@JeremysTutorials 5 месяцев назад
youre welcome!
@samxerox8144
@samxerox8144 3 месяца назад
THANKS YOU MADE IT EASY
@JeremysTutorials
@JeremysTutorials 3 месяца назад
you're welcome!
@aminadan2538
@aminadan2538 4 месяца назад
Easy to create, fantastic
@JeremysTutorials
@JeremysTutorials 4 месяца назад
thanks! appreciate it :)
@aleksranchinskaya9782
@aleksranchinskaya9782 22 дня назад
Thank you for the tutorial!
@JeremysTutorials
@JeremysTutorials 16 дней назад
gotchu 👌
@Azam_Lahore
@Azam_Lahore 5 месяцев назад
Thank you brother.
@JeremysTutorials
@JeremysTutorials 5 месяцев назад
you're welcome!
@mrigakheepatowary6609
@mrigakheepatowary6609 2 месяца назад
Hey thanks for the video it was quite helpful
@JeremysTutorials
@JeremysTutorials 2 месяца назад
Glad it helped
@chiamakandulue5778
@chiamakandulue5778 7 месяцев назад
Amazing!
@JeremysTutorials
@JeremysTutorials 7 месяцев назад
thank you!
@yenhoang4047
@yenhoang4047 2 месяца назад
Thank you so much.
@JeremysTutorials
@JeremysTutorials 2 месяца назад
you are very welcome
@sumanijigeesha6497
@sumanijigeesha6497 3 месяца назад
Thanks much!!
@JeremysTutorials
@JeremysTutorials 3 месяца назад
youre welcome 😊
@bishoy437
@bishoy437 Месяц назад
Thank you very much
@JeremysTutorials
@JeremysTutorials Месяц назад
you're welcome!
@MA-dd9dd
@MA-dd9dd День назад
wow wow wow
@peace.n.blessings5579
@peace.n.blessings5579 4 месяца назад
Thank you
@JeremysTutorials
@JeremysTutorials 4 месяца назад
youre welcome!
@claireantonette5523
@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
@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
@alexandervashchuk7795
@alexandervashchuk7795 6 месяцев назад
Thanks for #value
@JeremysTutorials
@JeremysTutorials 6 месяцев назад
you're welcome :)
@AnnRukutana
@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
@JeremysTutorials Месяц назад
can I see your formula?
@moesart7059
@moesart7059 53 минуты назад
Can't you share it?
@chalkandsweat
@chalkandsweat 2 месяца назад
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 25 дней назад
when i write TRUE just shows an error, i am so frustrated
@JeremysTutorials
@JeremysTutorials 23 дня назад
interesting, can you give your formula?
@agnestoding225
@agnestoding225 15 дней назад
me too😢
@feliperojas7838
@feliperojas7838 13 дней назад
you can try using ; instead of ,
@lucassantanadeoliveira8824
@lucassantanadeoliveira8824 6 месяцев назад
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
@finefrensonly
@finefrensonly 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 месяцев назад
@@finefrensonly can you type in your exact formula here?
@finefrensonly
@finefrensonly 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"})
@finefrensonly
@finefrensonly 6 месяцев назад
@@JeremysTutorialsThank you so much for your speedy reply :)
Далее
Habit Building System I Wish I Had Learned Sooner
4:48
Elon Musk to Give $45M / Month to Trump
14:59
Просмотров 1 тыс.
Super Simple Habit Tracker
4:45
Просмотров 548 тыс.
How To Create Your Own Habit Tracker
6:57
Просмотров 10 тыс.
CIS Video Project
5:34
Просмотров 4
Tiny motor, big power
0:25
Просмотров 39 млн