How to create your own Habit Tracker in Google Sheets - TUTORIAL + FREE TEMPLATE

#habittracker #googlesheets #tutorial

Some of you have been asking for Google Sheets Tutorials so I decided to start with a Habit Tracker. I tried to create it in a way that, at the same time I was showing you how to build it, I was also showing you a few tricks and formulas. So that's why it's such a long video. I hope you find it useful.

If you are already familiar with Google Sheets and don't want all the details you can change the video settings and make it play faster (2x).

📌 Link to FREE spreadsheet: https://tinyurl.com/yc888rf3
Please note: The template is sent automatically to your email (don’t forget to check your promotions folder). It should arrive within a few minutes, if it doesn’t please send an email to [email protected]

📌 If you would like to purchase an advanced version, you can check out the 12 MONTH HABIT TRACKER:    • Habit Tracker Template - Google Sheet...  

◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️

Formulas I mentioned (to copy and paste):

Horizontal progress bar:
=SPARKLINE(5,{"charttype","bar";"max",10;"color1","black"})

Vertical progress bar:
=SPARKLINE(50%,{"charttype","column";"ymin",0%;"ymax",100%;"color","black"})

Conditional formatting: Apparently angled brackets aren't allowed in the description so I couldn't complete the formula. Please pause the video and copy the formula manually.

HEX values I used:
"#d4c0c6"
"#726c8e"
"#544f6a"

◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️◻️

✨ You might also like ✨

📌 More FREE resources: https://thinklikeagirlboss.com/pages/...

📌 Shop Templates: https://thinklikeagirlboss.com

📌 Google Sheets Course - How to Create a Daily Schedule Template:
https://thinklikeagirlboss.thinkific....

Whether you're looking to boost your productivity, manage your money, or organize your home and daily life, these templates have you covered!

🔗 Meal Planner + Automated Grocery List: https://thinklikeagirlboss.com/produc...
🔗 Monthly Budget Spreadsheet: https://thinklikeagirlboss.com/produc...
🔗 Monthly Planner: https://thinklikeagirlboss.com/produc...
🔗 Social Media Content Planner: https://thinklikeagirlboss.com/produc...
🔗 Brain Dump and Idea Tracker: https://thinklikeagirlboss.com/produc...

I love spending my days creating spreadsheets, so stay tuned for more!

HAPPY PLANNING!

Pao 😊👩🏻‍💻✨