👉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
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
👉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
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).
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
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).
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?
👉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
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"}) :)
@@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.
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
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✨️
:(( 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
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
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✨️
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 your tutorial.. I'm happy to make this.. So simple and easy to follow 😍
how to make proggres? mine always erorrs
Planilha Maravilhosa, muito obrigada pelo tutorial!!! ❤❤❤
Hola! Quedé encantada por tu trabajo. Mil gracias!! ❤❤❤❤
🥰🥰
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!
Thank you so much for sharing your skills and knowledge❤❤❤
@@lynhennecyviado3272 ❤️❤️❤️❤️
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: th-cam.com/video/4n-ZgMRX07U/w-d-xo.htmlsi=YIK_RUrXyS_rVMfj
@@notedii thank
Thank you very much, very easy to use!
@@humanstrong-k1v 😁🥰🥰🥰
Thank you for this awesome tutorial💜
@@justasmallbeanie 😊😊😊😊🥰🥰 i'm glad that you like it
Could you up tutorial video of sleep tracker ??
Yes, girl,😊 next i will make a tutorial video of sleep tracker.
can you make a tutorial on the percent,
I can't
Thank you so much
😘😘😘
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!
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
❤❤❤
How was the percentage column made??
thank u so much , such a wonderful tutorial , keep sharing please
Eres la mejor, pikos ❤
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! 😊
Why i cant switch the sheet when im try to put the image in ?
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).
Not getting error is showing in the formula of putting plant inage
It's very useful ❤❤❤
Keep doing ❤
🥰🥰🥰
Thank you❤️
本当にすごい❤
有難う 御座いま🥰🥰
Thank you a lot, i will make this for 2025
I’m glad you found it helpful!🎉
hello, where can i find the pictures of the plant?
Thank u very much❤️
@@altarra3252 ❤️❤️❤️❤️
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
why no one is doing a mobile ready tracker, that looks good and easy to track on mobile?
thank you
thank you so much i appreciate about it
Thank 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).
@@dawnpefley1944 can you send me your spreadsheet through My insta @notediigram pls? I will check it for you
thanks aa lottt !!
@@thestoicsage310 🥰🥰🥰
Thanks❤❤❤
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!
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 🥰
Hi, i am watching this in 2024. How can I make the days until 31?
@@betheltorres2550 You can watch this video in 1:21 th-cam.com/video/nc6ReOcTyvM/w-d-xo.htmlsi=G44DRIi1VjfzlRJZ
I need help adding the plant
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 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?
Tolong tulis ulang semua formulanya, diberi keterangan
plants and percentage are not working ma'am. Please guide me.
in other comments she explained the percentage thing
Me too
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.
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
stress bgt, progress nya ga bisa bisa😢😢😢😢
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🥰
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✨️
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?
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.
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 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
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 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
=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 😢😢
If you want to create an attendance tracker quickly, this video is for you: th-cam.com/video/of_c-ctf2e4/w-d-xo.html ❤❤
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 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
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?