Це відео не доступне.
Перепрошуємо.
How To Make an Awesome Habit Tracker on Google Sheets in 10 Minutes ( FREE Template + Tutorial)
Вставка
- Опубліковано 17 сер 2024
- #habittracker #growplantingooglesheet
In this tutorial, you'll learn how to design a habit tracker in Google Sheets that'll help you boost productivity and monitor your progress using sparklines and tree planting.
You can also create this HT to sell it on Etsy
I sincerely appreciate you taking the time to watch my video :3
_______________
►Video section
0:00 : intro
0:15 : Set up
0:44 : Number the habits
1:16 : Insert the dates
2:00 : Insert checkboxes
2:11 : Insert the formula to count the habits
2:30 : Use formula to count completed habits
2:46 : Make sparkline to track progress
3:20 : Plan trees to track progress
7:32 : Tips and useful website to decor your template
9:25 : Intro the cute mood tracker
_______________
🌸Here's a free template for a habit tracker that you may find helpful: notedii.com/pr...
🌸My store: notedii.com/
_______________
🌸SOCIALS
Tiktok: / notediitiktok
Instagram: / notediigram
Pinterest: / notedii
#googlesheets #spreadsheet #habittracker #productive #moodtracker #todolist #habits #habittracking #goaltracker #etsyshop #etsy #freetemplate #tutorial
#googlesheets
Thank you so much! I made this! This is so simple and very easy to follow, formulas are basic too~
Thank you so much for your kind words❤️🫶🫶❤️❤️ I'm glad that it helps😊😊
Thank you a lot for watching my video :3
❤My store, you can buy cute templates here: 🤗If you're interested in purchasing more adorable templates, feel free to check out my store at: payhip.com/laplan
how to make proggres? mine always erorrs
If you want to create an attendance tracker quickly, this video is for you: ua-cam.com/video/of_c-ctf2e4/v-deo.html ❤❤
I need help adding the plant
Thank you so much! That's what I need the most!
Why i cant switch the sheet when im try to put the image in ?
Hola! Quedé encantada por tu trabajo. Mil gracias!! ❤❤❤❤
🥰🥰
hello, I need help with how to make it count the checkboxes. It can be because my Google is Swedish. Due to I am from Sweden. Can really use some help. Because it always says two even when I fill out a box
i fixed it so it only says one instead of two and it still working. I just removed the true on the countif command
@@llCindyll hi can you send me your spreadsheet through my insta notediigram? I will check it and help you fix the error
What if I have like 14 image to put in the cell? I tried to copy the same formula you use here but its not working for me
Thank you a lot!
Just by the way, how did you do the percentage column at 04:08?
can you plz tell
👉If you already have the completed column, So you just need to use the completed cell devide the number of days in that month then choose %
For example: A1/31 then choose % (A1 is the number of tasks that you completed, 31 is the days of the month )
👉 if you don't have the completed column
use can use this formula
=countif(G5:AK5, true)/31
( G5:AK5 is the range of tickboxes, 31 is the number of days in the month)
😘I hope that it is helpful for you
@@notedii thank you so much
Cara ubah Nilanya jadi persen gak desimal@@notedii
@@irsaltriwahyuputra1331 Anda dapat merujuk ke video ini: ua-cam.com/video/4n-ZgMRX07U/v-deo.htmlsi=YIK_RUrXyS_rVMfj
@@notedii thank
What is the formula for the % column?
👉If you already have the completed column, So you just need to use the completed cell devide the number of days in that month then choose %
For example: A1/31 then choose % (A1 is the number of tasks that you completed, 31 is the days of the month )
👉 if you don't have the completed column
use can use this formula
=countif(G5:AK5, true)/31
( G5:AK5 is the range of tickboxes, 31 is the number of days in the month)
😘I hope that it is helpful for you
@@notedii Thank you! 😊
本当にすごい❤
有難う 御座いま🥰🥰
Could you up tutorial video of sleep tracker ??
Yes, girl,😊 next i will make a tutorial video of sleep tracker.
thank u so much , such a wonderful tutorial , keep sharing please
why no one is doing a mobile ready tracker, that looks good and easy to track on mobile?
Thank you so much
😘😘😘
How do you select all the columns like that in yellow at 02:32? Do you hold any key while at it?
In the video, I didnt hold any key, i just use mouse to select them. However, you can also try this: You can click the first cell in the table row, and then press CTRL+SHIFT+RIGHT ARROW.❤
@@notediiDon't worry I was doing the spreadsheet in Excel, I didn't realize this was in Google. I succeded and had no problem. Thank you a lot! Just by the way, how did you do the percentage column at 02:42?
@@notedii Sorry I didn't realize you already expained it in other comments, how did you put the date? at 1:15
@@ramirosotto u can press Ctrl + ;
@@notedii It worked! It looks beautiful. Thank you a lot, wish you a great 2024!
I have no card, how can I get the template?
Eres la mejor, pikos ❤
thank you so much i appreciate about it
Thank you🥰
plants and percentage are not working ma'am. Please guide me.
in other comments she explained the percentage thing
❤❤❤
It's very useful ❤❤❤
Thanks❤❤❤
Hey, the sparkline formula doesn't seem to be working. Can you help me. Thanks
You try copy and paste this one: =SPARKLINE(AI5,{"CHARTTYPE","BAR";"MAX",100%;"COLOR1","CCD5AE"})
Some notes for you:
- AI5: This is the cell that contains %
- CCD5AE: you can change this color code to the one that you like.
I'm sorry but this is still not working🙁
@@notedii hey, what can you do if it's still not working?
Hi, I had the same problem! Here is how I resolved it! Do not include "%" into the code! DO it this way: =SPARKLINE(V7,{"CHARTTYPE","BAR";"MAX",100;"COLOR1","CCD5AE"}) :)
For the plant, do you have specific size of picture for it to work? Or GSheets will automotically scale it to fit the cell?
Gsheets will scale them. so I need to make sure all the pics have the same size
@@notedii I see, thank you so much!
thanks aa lottt !!
@@thestoicsage310 🥰🥰🥰
Are there any formulas in the flower pot cell? How can I resolve it? Please help
=iferror(if(D18
@@notedii why does the flower is not growing? And it remained to be a flower tho the checkbox arent checked yet. Is the formula the problem?
@@mikes2515 maybe your formula is not edited to fit your sheet. Don't worry. Can you send me your spreadsheet through my insta "Notediigram", please?. I will check your sheet and fix error for you
@@notedii done, thank you so much!
@@mikes2515 I'm really glad to receive your message, I just checked and edited it, please check my message, if you have any questions, feel free to tell me.
Hi, i am watching this in 2024. How can I make the days until 31?
@@betheltorres2550 You can watch this video in 1:21 ua-cam.com/video/nc6ReOcTyvM/v-deo.htmlsi=G44DRIi1VjfzlRJZ
Keep doing ❤
🥰🥰🥰
Thank you❤️
How did you make the percentage ?
👉If you already have the completed column, So you just need to use the completed cell devide the number of days in that month then choose %
For example: A1/31 then choose % (A1 is the number of tasks that you completed, 31 is the days of the month )
👉 if you don't have the completed column
use can use this formula
=countif(G5:AK5, true)/31
( G5:AK5 is the range of tickboxes, 31 is the number of days in the month)
😘I hope that it is helpful for you
@@notedii gracias 🥰
When im using the formula for the tree planter tracker i am getting a formula parse error.. Any solution??
Can you share me your sheet, please? I will check that for you❤️
@@notedii sure but how? Via link, here?
@@MahiSh25 you can send me here or via my insta. @notediigram
@@notedii sent
@@MahiSh25 I just fixed that for you, please check it, I hope that it help🥰
How can I download it
You can go to this link: payhip.com/b/4X7jF 🥰
Is it free or paid
@@CipherGhostlhy 😅 it's 100% free
It not work in excel
@@CipherGhostlhy yes🤣 of course. It can only work in google sheets
Hey, what if we add habit what about plants because we have only added 3 images so it wont work for more than 3 habits?
And please link for images of plant
It works based on the % of your tasks done, the number of habits doesn't matter. Even if you have 10000000 habits, it still works.Please watch the video again😭 i alreadg explain it very detailed about the formular
About the link for images of plant, you can find them on Canva.
hi the sparkline formula isnt working
:(( no babe, it works. But you can not use my exact formula in your spreadsheet, you need to change the data range according to yours. Can you send me your spreadsheet through insta: Notediigram. I will check your formula and help you fix it
How did you get the plant images please
You can find them on Canva❤️
@@notedii thank you so much. Is there a particular keyword I could use to get them? Or do I have to create them myself?
where can i get these tree emojies, I want these
You can get them on Canva or Freepik❤️
@@notediiHow do I find it? What is it called?
Do you have daily task tracker like that
You can visit my store, i have several choices for you: payhip.com/theaugustinnovations
=iferror(if(D18
can you give me the link of your sheets, so i can check it.
Issue solved. Thank you. I like tracker so much.
@@notedii docs.google.com/spreadsheets/d/1f7CT4gygUxmXwKFl2yCfX2W1sMc1itvT1K8q38NZwBQ/edit#gid=0 ---- Can u help me with this link, my pots don't change even I tick the blank 😢😢
I am little confused with percentage
👉If you already have the completed column, So you just need to use the completed cell devide the number of days in that month then choose %
For example: A1/31 then choose % (A1 is the number of tasks that you completed, 31 is the days of the month )
👉 if you don't have the completed column
use can use this formula
=countif(G5:AK5, true)/31
( G5:AK5 is the range of tickboxes, 31 is the number of days in the month)
😘I hope that it is helpful for you
@@notedii no please simplyfy it i am still not getting it tell me how you applied formula in your exact chart as i have made same chart as yours so explain what should I type and how it will appear
@@pranjaltupe6251 =countif(G5:AK5, true)/31 you can try this one
@@notedii what's your email ?
@@notedii thank you very much it worked
how to make %
because you skip it
❤️If you already have the completed column, So you just need to use the completed cell devide the number of days in that month then choose %
For example: A1/31 then choose % (A1 is the number of tasks that you completed, 31 is the days of the month )
👉 if you don't have the completed column
use can use this formula
=countif(G5:AK5, true)/31
( G5:AK5 is the range of tickboxes, 31 is the number of days in the month)
😘I hope that it is helpful for you
@@notedii can you make a video to this problem because it is never come to me
THANKS ITS WORKED
BUT THE PERCENTAGE COME LIKE 0.00%
HOW TO CANGE IT
it is ok i learn ready
I have no card, how can I get the template?
This is totally free so just need to add it to cart and click proceed purchase. After you click pay with paypal (it will lead you to the download link)✨️✨️ thank you for choosing notedii. Happy tracking✨️
I have no card, how can I get the template?
This is totally free so just need to add it to cart and click proceed purchase. After you click pay with paypal (it will lead you to the download link)✨️✨️ thank you for choosing notedii. Happy tracking✨️