Create an Automated Habit Tracker in Google Sheets - Part 1 Tutorial

Подписаться 436

Просмотров 11 тыс.

50% 1

🎬 Are you looking to streamline your daily routines and improve your productivity? In this video, we show you how to create an Automated Habit Tracker using Google Sheets!
🌟 Learn step-by-step how to set up a custom tracker that will help you monitor your habits, set goals, and visualize your progress over time. We’ll guide you through the essential functions and formulas to automate your tracking, making it easier than ever to stay on top of your commitments. Whether you're trying to build new habits, break old ones, or simply maintain consistency, this Google Sheets tracker will be your ultimate tool.
🗓️ 🌟 Access Final Part through the following link:
• Create an Automated Ha...
🔗 Here is the link for you to download the image as shown in the video:
bit.ly/3zPOBgT
Best of luck on your daily progress tracking journey! 🌟🚀
0:00:08 Intro
0:00:42 Create table
0:03:55 Format
0:06:32 Data visualization
0:18:00 Conditional Formatting
#googlesheets #habittracker #todolist #monthlygoals #monthlytasks #tutorial #adhd #fuukojournal
........................................................................................................................................................................
If you're interested in exploring more content, check out my playlists:
📝 ADHD Spreadsheets: • ADHD Spreadsheets
📊 Data Visualization with Excel: • Data Visualization | E...
📈 Data Visualization with Power BI: • Data Visualization | P...
💡 Excel Tips and Tricks: • Excel Tips & Tricks
🔜 Coming Soon:
📊 Data Visualization with PowerPoint
🎨 Data Visualization with Adobe Illustrator
🐍 Data Visualization with Python
💡 Tips, Tricks, and Formulas for Spreadsheet Tools and Power BI
Make sure to like, comment, and subscribe for more tutorials, tips, and insights on using spreadsheet tools and creating powerful data visualizations!

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

8 окт 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 48

@FuukoJournal 2 месяца назад

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

@simstoryteller2897 6 месяцев назад

This is so wonderful!! Please continue this series. I love it.

@FuukoJournal 3 месяца назад

Thank you very much, I will try to continue this series as soon as possible.

@SagarMadhukar 5 дней назад

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 5 дней назад

Hey! I got the solution at the very beginning of Part 2 of the video! Sorry to have bothered you! Thanks! :)

@FuukoJournal 5 дней назад

@@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. 😓

@SagarMadhukar 5 дней назад

@@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! :)

@FuukoJournal 5 дней назад

@@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! :)

@SagarMadhukar 5 дней назад

@@FuukoJournal You’re welcome, Fuuko! Will reach out to you soon! :) Take care! 💛💛

@RayneChecks 3 месяца назад

I learned so much from this, thank you!

@FuukoJournal 3 месяца назад

Thank you for your comment.

@mennaibrahim4165 Месяц назад

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?

@FuukoJournal Месяц назад

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.

@mennaibrahim4165 Месяц назад

@@FuukoJournal Thanks for your reply!

@Vishnuway 22 дня назад

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?

@FuukoJournal 22 дня назад

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.

@hooneyvlog.13 18 дней назад

maybe can check the linked cell

@mennaibrahim4165 Месяц назад

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?

@FuukoJournal Месяц назад

Hello, thank you for your interest in my video. Of course, you can change the images-feel free to choose the ones you like!"

@fbrnt 9 дней назад

02:08 What should I click so that it can show the number below it?

@FuukoJournal 9 дней назад

Hello, in cell B5, type =B4, then drag the formula to the right.

@mohamednourqaadi1374 2 месяца назад

Thanks this good interest me

@FuukoJournal 2 месяца назад

Thank you

@wiscogirl3 3 месяца назад

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) "

@FuukoJournal 3 месяца назад

Hi, please try this one: "=IF(OR(EOMONTH($A$3,0)=AD8,AD8=""),"",AD8+1)" Thank you for your comment

@wiscogirl3 3 месяца назад

@FuukoJournal I'll try that, thank you!!

@amandhasanti7273 Месяц назад

14:55 Could you please explain to me how you deleted the number of the 3rd, 4rd, 5rd, etc from the cells AI

@FuukoJournal Месяц назад

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?

@amandhasanti7273 Месяц назад

@@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?

@FuukoJournal Месяц назад

@@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!

@amandhasanti7273 Месяц назад

@@FuukoJournal thanks for your replay

@manondiab5472 Месяц назад

please help me. When I change the month, the names of the days don't change.

@FuukoJournal Месяц назад

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!

@FuukoJournal Месяц назад

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.

@manondiab5472 Месяц назад

@@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!

@FuukoJournal Месяц назад

@@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!

@ahmadfathinhaidar2784 26 дней назад

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.

@FuukoJournal 26 дней назад

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.

@FuukoJournal 24 дня назад

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 24 дня назад

@@FuukoJournal I sent it just now. I hope you can check back. sorry in advance🙏🏻❤

@FuukoJournal 24 дня назад

@@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 RU-vid 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!