🌟 We are excited to announce that our shop officially opened on October 20, 2024! 🌟 👉 Link to the shop: fuukojournal.com/shop/ New products will be launched quickly, so stay tuned!
Don't forget to subscribe to Fuuko Journal for more exciting content! Click the link and join our community today! 🎉📚 www.youtube.com/@FuukoJournal/?sub_confirmation=1
Hello, I wanted to thank you endlessly for sharing this video tutorial; it’s been incredibly helpful to me. It took me a couple of hours to complete, but the video explains itself perfectly. I encourage you to keep making videos like this one. ✌🏽
Hi Fukoo Thank you and happy to meet your amazing content. thank you so much for your sharing this video. May i know for the formula of Conditional Formatting? I have a trouble when you write the formula looks unclear in video.. thank you
Hello. Could you help me please? I got a problem in 11:41. I already used the formula but in March the check box are missing like February. Can I send you the file for fixed my problem?
Hello, thank you for following my tutorial video. To answer your question, I'll break down the formula step by step: Formula: '=IF(OR(EOMONTH($A$3,0)=AD8,AD8=""),"",AD8+1)' + 'EOMONTH($A$3,0)' is used to determine the last day of the month based on the date in cell $A$3. In this case, the selected month is February 2023, and the last day is 28/02/2023. + 'EOMONTH($A$3,0)=AD8' checks whether the date in the previous cell (cell AD8) is the last day of the month. If it is, then the current cell will be left empty. + 'AD8=""' checks whether the previous cell is empty. Without this condition, if cell AD8 were empty, the result in the current cell would be 1 (since the formula adds 1 to an empty cell). In summary, this formula means that if the previous cell is either the last day of the month or is empty, then the current cell will also be left empty. Otherwise, the formula adds 1 day to the date in the previous cell. With this logic, the dates of the 1st, 2nd, and 3rd of the next month are not displayed under the "Week 5" label because they fall into the new month, and the formula is set to avoid displaying them. I hope my explanation has clarified things for you.
Hey Fuuko! Really glad to have found you! You have earned a subscriber! :) 19:51 I had a query here, how did you manage to get rid of all the zeroes that were next to the Daily Habits column (the column which are counting the true checkboxes), whose habits were not listed yet? If you rewind just 2 seconds, it looked as if there was a cut made in the video, so couldn’t follow it! Thanking you in anticipation! :)
@@SagarMadhukar Hi Sagar, thank you so much for subscribing to my channel. I’m really glad you figured it out! You’re absolutely right, there was indeed a cut in that part when I reviewed it. Since this is my first video, I made quite a few mistakes, and that was one of them. 😓
@@FuukoJournal Hey that's completely okay! :) Afterall content is the king, and you have already done an amazing job! :) Also, I am also inclined towards Data Analytics and visual representation. Went through your website and read some amazing articles which you have written! Would love to get in touch with you in near future, to take some advice on how to go about becoming a data analyst as good as you! :) Have a great day ahead, Fuuko! :) Thanks a ton! :)
@@SagarMadhukar Thank you so much! I'm glad you enjoyed the content on my website. If you ever need advice on data analysis, I'd be happy to help. Have a great day, and I hope you become a great data analyst soon! :)
Yes, you can duplicate it once to have all 12 months. After that, you only need to duplicate the file for each new year. This way, you'll save time and always have a set of 12 months ready for each year without having to recreate it from scratch each time.
Hi, I'm not exactly sure what happened. You might want to try refreshing your browser (press F5). Sometimes Google Sheets doesn’t run the formulas for me when I update new data, and it could be due to an internet issue. If that doesn’t work, feel free to share the link to your file to my email at fuukojournal@gmail.com, and I’ll take a look.
Hello, thank you for following my tutorial. I'm not quite sure I understand your question. Could you please provide more details so I can assist you better?
@@FuukoJournal At 14.53 seconds in column AJ there is the number 13/20, then when you drag it down the only column that has content is in the column, while for those without content the number 0/20 does not appear. How do I prevent columns that have no contents from appearing 0/20 or empty?
@@amandhasanti7273 Ah, I understand your question now. To prevent the 0/20 from appearing, I used an IF statement. Specifically, if the corresponding cell in column A is empty, then the corresponding cell in column AJ will also be empty. You can refer to the formula I used in AJ110 as follows: =IF(A10="","",B10&"/"&COUNT($C$8:$AG$8)) If you encounter any further issues, don't hesitate to leave a comment!
Hi there, Thanks so much for watching my video! I’m really sorry to hear you're having trouble. If you’re sure you followed the formula correctly but still have issues, please don’t hesitate to share the link to your file with me via email at fuukojournal@gmail.com. I’d be happy to take a look and help figure out what’s going wrong. Thanks again!
Hello, I just wanted to check in-have you been able to resolve the issue? I've been looking out for an email notification but haven't seen one yet. If you haven't resolved it yet, feel free to send me an email, don't hesitate.
@@FuukoJournal Hello, I’ve resolved the issue, thank you so much! I would love to send you an email with my application of your tutorials for your feedback. I’m currently working on the final tutorial and will likely finish it in two days. Once I’m done, I’ll let you know when I’ve sent the email, in case you’d like to take a look. Thanks again for all your help!
@@manondiab5472 Hello, I’m glad to hear that you’ve resolved the issue on your own. If you encounter any more problems, please don’t hesitate to get in touch with me. Wishing you success with your final tutorial!
Sorry for the late reply. I've been quite busy lately, so I haven't been paying much attention to the TH-cam channel. Could you please send your file link to my email at fuukojournal@gmail.com? With the file, it will be easier for me to find the reason and explain it to you more clearly.
i think there's i a small error with the separator elements. maybe you make i in array format () but should be in array format {} =SPARKLINE(A10, {"charttype", "bar"; " max", 1; "color1", "#7C8602"})
Hi, I have an error in the February part of week 5. Can I send you a video of the problem via Gmail? I've spent a long time trying to fix it but to no avail.
Hi, of course. You can send it to me via email at fuukojournal@gmail.com. However, if possible, please send me a link to the file, as that might make it easier for me to identify the issue and assist you better.
Hi, did you receive my message? I don't see your file in my email at the moment. I'm wondering if you have already managed to solve the problem on your own?
@@ahmadfathinhaidar2784 Hello, I've received your email and made the adjustments directly in the file. You're doing a great job, and the colors look fantastic! P.S.: No worries at all! I was just concerned TH-cam might have an issue and you wouldn't see my message. This happened to me before when someone commented, and I didn’t get the notification. Not sure why!
Thank you so much for sharing this tutorial! Could you explain the eomonth formula? I'm getting an error when I enter" =IF(OR(EOMONTH($A$3,0)=AD8,AD8=**),**,AD8+1) "
🌟 We are excited to announce that our shop officially opened on October 20, 2024! 🌟
👉 Link to the shop: fuukojournal.com/shop/
New products will be launched quickly, so stay tuned!
I just purchased it, thank you. It's wonderful!
@@ErlendHerd Thank you for your support! If you have any questions during your usage, please don't hesitate to email me.
This is so wonderful!! Please continue this series. I love it.
Thank you very much, I will try to continue this series as soon as possible.
Don't forget to subscribe to Fuuko Journal for more exciting content! Click the link and join our community today!
🎉📚 www.youtube.com/@FuukoJournal/?sub_confirmation=1
Hello, I wanted to thank you endlessly for sharing this video tutorial; it’s been incredibly helpful to me. It took me a couple of hours to complete, but the video explains itself perfectly. I encourage you to keep making videos like this one. ✌🏽
Thank you so much for the kind words! It's awesome you were able to create your own habit tracker. 💖
Hi Fukoo Thank you and happy to meet your amazing content. thank you so much for your sharing this video. May i know for the formula of Conditional Formatting? I have a trouble when you write the formula looks unclear in video.. thank you
Hello. Could you help me please? I got a problem in 11:41. I already used the formula but in March the check box are missing like February. Can I send you the file for fixed my problem?
11:37
Could you please explain to me how you deleted the dates of the 1st, 2nd, and 3rd from the cells below the 'Week 5' label?
Hello, thank you for following my tutorial video.
To answer your question, I'll break down the formula step by step:
Formula: '=IF(OR(EOMONTH($A$3,0)=AD8,AD8=""),"",AD8+1)'
+ 'EOMONTH($A$3,0)' is used to determine the last day of the month based on the date in cell $A$3. In this case, the selected month is February 2023, and the last day is 28/02/2023.
+ 'EOMONTH($A$3,0)=AD8' checks whether the date in the previous cell (cell AD8) is the last day of the month. If it is, then the current cell will be left empty.
+ 'AD8=""' checks whether the previous cell is empty. Without this condition, if cell AD8 were empty, the result in the current cell would be 1 (since the formula adds 1 to an empty cell).
In summary, this formula means that if the previous cell is either the last day of the month or is empty, then the current cell will also be left empty. Otherwise, the formula adds 1 day to the date in the previous cell. With this logic, the dates of the 1st, 2nd, and 3rd of the next month are not displayed under the "Week 5" label because they fall into the new month, and the formula is set to avoid displaying them.
I hope my explanation has clarified things for you.
@@FuukoJournal Thanks for your reply!
Hi could you please tell about how to make the cat image, what application you used?
Thank you so much
I take this picture from the web leonardo.ai/. You can give it a try,:D
Hey Fuuko! Really glad to have found you! You have earned a subscriber! :)
19:51 I had a query here, how did you manage to get rid of all the zeroes that were next to the Daily Habits column (the column which are counting the true checkboxes), whose habits were not listed yet? If you rewind just 2 seconds, it looked as if there was a cut made in the video, so couldn’t follow it!
Thanking you in anticipation! :)
Hey! I got the solution at the very beginning of Part 2 of the video! Sorry to have bothered you! Thanks! :)
@@SagarMadhukar Hi Sagar, thank you so much for subscribing to my channel.
I’m really glad you figured it out! You’re absolutely right, there was indeed a cut in that part when I reviewed it. Since this is my first video, I made quite a few mistakes, and that was one of them. 😓
@@FuukoJournal Hey that's completely okay! :) Afterall content is the king, and you have already done an amazing job! :)
Also, I am also inclined towards Data Analytics and visual representation. Went through your website and read some amazing articles which you have written! Would love to get in touch with you in near future, to take some advice on how to go about becoming a data analyst as good as you! :)
Have a great day ahead, Fuuko! :) Thanks a ton! :)
@@SagarMadhukar Thank you so much! I'm glad you enjoyed the content on my website. If you ever need advice on data analysis, I'd be happy to help.
Have a great day, and I hope you become a great data analyst soon! :)
@@FuukoJournal You’re welcome, Fuuko! Will reach out to you soon! :) Take care! 💛💛
Do you have to duplicate the sheet each month? Or is it done automatically?
Yes, you can duplicate it once to have all 12 months. After that, you only need to duplicate the file for each new year. This way, you'll save time and always have a set of 12 months ready for each year without having to recreate it from scratch each time.
02:08 What should I click so that it can show the number below it?
Hello,
in cell B5, type =B4, then drag the formula to the right.
Hey there, I'm having an issue where the days of the week don't update when I change the month. Any suggestions on how to fix this?
Hi, I'm not exactly sure what happened. You might want to try refreshing your browser (press F5). Sometimes Google Sheets doesn’t run the formulas for me when I update new data, and it could be due to an internet issue.
If that doesn’t work, feel free to share the link to your file to my email at fuukojournal@gmail.com, and I’ll take a look.
maybe can check the linked cell
I learned so much from this, thank you!
Thank you for your comment.
14:55
Could you please explain to me how you deleted the number of the 3rd, 4rd, 5rd, etc from the cells AI
Hello, thank you for following my tutorial.
I'm not quite sure I understand your question. Could you please provide more details so I can assist you better?
@@FuukoJournal At 14.53 seconds in column AJ there is the number 13/20, then when you drag it down the only column that has content is in the column, while for those without content the number 0/20 does not appear. How do I prevent columns that have no contents from appearing 0/20 or empty?
@@amandhasanti7273
Ah, I understand your question now. To prevent the 0/20 from appearing, I used an IF statement. Specifically, if the corresponding cell in column A is empty, then the corresponding cell in column AJ will also be empty. You can refer to the formula I used in AJ110 as follows:
=IF(A10="","",B10&"/"&COUNT($C$8:$AG$8))
If you encounter any further issues, don't hesitate to leave a comment!
@@FuukoJournal thanks for your replay
Can I change the cat images used in the video after the project is completely finished, or will I find it difficult to do so?
Hello, thank you for your interest in my video.
Of course, you can change the images-feel free to choose the ones you like!"
please help me.
When I change the month, the names of the days don't change.
Hi there,
Thanks so much for watching my video!
I’m really sorry to hear you're having trouble. If you’re sure you followed the formula correctly but still have issues, please don’t hesitate to share the link to your file with me via email at fuukojournal@gmail.com. I’d be happy to take a look and help figure out what’s going wrong.
Thanks again!
Hello, I just wanted to check in-have you been able to resolve the issue? I've been looking out for an email notification but haven't seen one yet. If you haven't resolved it yet, feel free to send me an email, don't hesitate.
@@FuukoJournal
Hello, I’ve resolved the issue, thank you so much!
I would love to send you an email with my application of your tutorials for your feedback. I’m currently working on the final tutorial and will likely finish it in two days. Once I’m done, I’ll let you know when I’ve sent the email, in case you’d like to take a look.
Thanks again for all your help!
@@manondiab5472
Hello,
I’m glad to hear that you’ve resolved the issue on your own. If you encounter any more problems, please don’t hesitate to get in touch with me.
Wishing you success with your final tutorial!
Could you please explain to me how make sparkline?? mine always error T^T
Sorry for the late reply. I've been quite busy lately, so I haven't been paying much attention to the TH-cam channel. Could you please send your file link to my email at fuukojournal@gmail.com? With the file, it will be easier for me to find the reason and explain it to you more clearly.
i think there's i a small error with the separator elements. maybe you make i in array format () but should be in array format {}
=SPARKLINE(A10, {"charttype", "bar"; " max", 1; "color1", "#7C8602"})
It's a pity that there is music instead of you explaining.. 🙁
Hi, I have an error in the February part of week 5. Can I send you a video of the problem via Gmail? I've spent a long time trying to fix it but to no avail.
Hi, of course. You can send it to me via email at fuukojournal@gmail.com. However, if possible, please send me a link to the file, as that might make it easier for me to identify the issue and assist you better.
Hi, did you receive my message? I don't see your file in my email at the moment. I'm wondering if you have already managed to solve the problem on your own?
@@FuukoJournal I sent it just now. I hope you can check back. sorry in advance🙏🏻❤
@@ahmadfathinhaidar2784
Hello, I've received your email and made the adjustments directly in the file. You're doing a great job, and the colors look fantastic!
P.S.: No worries at all! I was just concerned TH-cam might have an issue and you wouldn't see my message. This happened to me before when someone commented, and I didn’t get the notification. Not sure why!
Thanks this good interest me
Thank you
Thank you so much for sharing this tutorial! Could you explain the eomonth formula? I'm getting an error when I enter" =IF(OR(EOMONTH($A$3,0)=AD8,AD8=**),**,AD8+1) "
Hi, please try this one:
"=IF(OR(EOMONTH($A$3,0)=AD8,AD8=""),"",AD8+1)"
Thank you for your comment
@FuukoJournal I'll try that, thank you!!
Share the images used in your tutorial
Hello, thank you for your advice.
I have already attached the link in the video description.
@@FuukoJournal 😚
@@annalisearen 🥰🥰
太狂了
Thankyou
You're amazing. thank you so much
please subscribe everyone !!
You deserve so much better 🥲💗
Thank you.
Your comment means a lot to me.