👉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
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?
There is an error in putting 0lant image in my original sheet i saved an image from google then from painting i crop all the diffrent stages and the paste in cell then selected cell, selected inage three dots and put into cell
At first I also had an error, but after I fiddled with it a few times, the problem was in the "comma" => if the formula in the video =SPARKLINE(A15,{CHARTTYPE","BAR";"MAX",100%;"COLOR1"," BLACK"}) whereas what I used and it worked =SPARKLINE(A15;{"CHARTTYPE"\"BAR";"MAX"\100%;"COLOR1"\"BLACK"}) Good luck
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
👉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
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
Thank you so much for this! However, may I as what to do if I did this horizontally (because i made an academic tracker and added this growing tree effect on the last column) how do I spread the plant down so that I don't have to edit the formula one by one? I tried what you did but it doesn't work the same way, maybe because I did this horizontally instead of vertically like you. Please help, I've been so stressed trying to figure out what to do because I've been editing it one-by-one so far and im really getting tired of doing so.
@@Luna-xi8qx Can you send me your spreadsheet through my insta @notediigram. I will check it for you. I think you should add the "$" to make the the cells (pics) fixed.
I don't know exactly what you are asking (because I just started to watch videos about this today 😁) but I watched on another video that the type of graphic (the progress column) changed from "bar" to "column" when that progress column was made in place of the plant images (down). So maybe I'm not helping, but check if what you are asking has something to do with that (changing the formulta , the part where they put column to bar or the opposite).
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.
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"}) :)
👉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
help! I cannot get the slackline formula to work for me. I'm in the US, i copied the exact formula (but put A14 since that's what you typed in your workbook).
@@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
@@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.
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 great need to make it. But I can't understand even in this language and I don't have proper knowledge of excel, please anyone can help me to make it in Hindi language.
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
:(( 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
👉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
@@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 😢😢
❤️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
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 great need to make it. But I can't understand even in this language and I don't have proper knowledge of excel, please anyone can help me to make it in Hindi language.
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 for the tutorial! really helpful, finally I can make my own habit tracker
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
How did you make the percentage?
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!
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!
thank you so much!! i had so much grateful to find this video and thanks for the free template. this is what i am really looking for!
There is an error in putting 0lant image in my original sheet i saved an image from google then from painting i crop all the diffrent stages and the paste in cell then selected cell, selected inage three dots and put into cell
thankyou so much for the template, so niceee
how to make proggres? mine always erorrs
At first I also had an error, but after I fiddled with it a few times, the problem was in the "comma" => if the formula in the video =SPARKLINE(A15,{CHARTTYPE","BAR";"MAX",100%;"COLOR1"," BLACK"})
whereas what I used and it worked =SPARKLINE(A15;{"CHARTTYPE"\"BAR";"MAX"\100%;"COLOR1"\"BLACK"}) Good luck
@@shita9795thanks
How was the percentage column made??
Not getting error is showing in the formula of putting plant inage
Could you up tutorial video of sleep tracker ??
Yes, girl,😊 next i will make a tutorial video of sleep tracker.
Hola! Quedé encantada por tu trabajo. Mil gracias!! ❤❤❤❤
🥰🥰
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
Thank you soo much for the tutorial !! Btw where do you get the plant picture?
Thank you so much! That's what I need the most!
hello, where can i find the pictures of the plant?
Why do I always ERROR when I want to give the formula to Completed? 😢😢
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! 😊
Thank you for your tutorial.. I'm happy to make this.. So simple and easy to follow 😍
thank you babe... i will make my own luv u
It's awesome. Thank you very much
💌
Why i cant switch the sheet when im try to put the image in ?
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
Thank you so much for this! However, may I as what to do if I did this horizontally (because i made an academic tracker and added this growing tree effect on the last column) how do I spread the plant down so that I don't have to edit the formula one by one? I tried what you did but it doesn't work the same way, maybe because I did this horizontally instead of vertically like you. Please help, I've been so stressed trying to figure out what to do because I've been editing it one-by-one so far and im really getting tired of doing so.
@@Luna-xi8qx Can you send me your spreadsheet through my insta @notediigram. I will check it for you. I think you should add the "$" to make the the cells (pics) fixed.
I don't know exactly what you are asking (because I just started to watch videos about this today 😁) but I watched on another video that the type of graphic (the progress column) changed from "bar" to "column" when that progress column was made in place of the plant images (down). So maybe I'm not helping, but check if what you are asking has something to do with that (changing the formulta , the part where they put column to bar or the opposite).
Thank you very much, very easy to use!
@@humanstrong-k1v 😁🥰🥰🥰
Planilha Maravilhosa, muito obrigada pelo tutorial!!! ❤❤❤
Thank you for this awesome tutorial💜
@@justasmallbeanie 😊😊😊😊🥰🥰 i'm glad that you like it
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.
@@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"}) :)
=SPARKLINE(AH5;{"charttype"\"bar";"max"\30})
@@yektiratnasari7910 This is much easier.
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 🥰
plants and percentage are not working ma'am. Please guide me.
in other comments she explained the percentage thing
Me too
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
Thank you so much
😘😘😘
help! I cannot get the slackline formula to work for me. I'm in the US, i copied the exact formula (but put A14 since that's what you typed in your workbook).
@@dawnpefley1944 can you send me your spreadsheet through My insta @notediigram pls? I will check it for you
Thank you so much for sharing your skills and knowledge❤❤❤
@@lynhennecyviado3272 ❤️❤️❤️❤️
can you make a tutorial on the percent,
I can't
Eres la mejor, pikos ❤
Keep doing ❤
🥰🥰🥰
Thank you❤️
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
I need help adding the plant
❤❤❤
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.
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?
Great video, but you left us hanging with the percentage. Please tell how to do the percentage because im struggling to do it by myself
It's very useful ❤❤❤
If you want to create an attendance tracker quickly, this video is for you: ua-cam.com/video/of_c-ctf2e4/v-deo.html ❤❤
please I can't use formula sparkline
@@fradiktajr.7316 can you send me your spreadsheet through my insta @notediigram. I will check and fix that for you
@@fradiktajr.7316 the formula may be affected by location. You can try changing your location in the spreadsheet to USA and try the formula again.
Thank u very much❤️
@@altarra3252 ❤️❤️❤️❤️
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✨️
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🥰
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?
The templated was deleted, how could I get 😢😢
@@Nalihatsune9745 hi. I just restore it. Can you click the link provided in the pdf again :(( ? Please let me know if you still can not access it
本当にすごい❤
有難う 御座いま🥰🥰
I have great need to make it. But I can't understand even in this language and I don't have proper knowledge of excel, please anyone can help me to make it in Hindi language.
thank you so much i appreciate about it
Thank you🥰
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.
Do you have daily task tracker like that
You can visit my store, i have several choices for you: payhip.com/theaugustinnovations
why no one is doing a mobile ready tracker, that looks good and easy to track on mobile?
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
thanks aa lottt !!
@@thestoicsage310 🥰🥰🥰
thank you
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
thank u so much , such a wonderful tutorial , keep sharing please
Thanks❤❤❤
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
Thank you a lot, i will make this for 2025
I’m glad you found it helpful!🎉
stress bgt, progress nya ga bisa bisa😢😢😢😢
Tolong tulis ulang semua formulanya, diberi keterangan
=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 😢😢
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
Thank you so much❤
The sparkline formula does not working. Im not sure why
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 great need to make it. But I can't understand even in this language and I don't have proper knowledge of excel, please anyone can help me to make it in Hindi language.
I have no card, how can I get the template?