How to create your own Habit Tracker in Google Sheets - 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).

You can either follow along with this tutorial for free or purchase the template from the store linked in the channel description.

Keep track of your daily habits with this easy to use habit tracker spreadsheet for Google Sheets! This 1 tab spreadsheet is easy to use and allows you to keep track of up to 23 daily habits. Simply click the checkboxes and the graphs and totals update automatically for you!

Purchase on:

Weebly: https://inhelpdesigns.weebly.com/#/

FEATURES
• easily change the month with one click
• daily goals and per habit goals
• graphs to keep track of your progress
• up to 23 daily habits
• multiple progress charts
• detailed tutorial video included!
• track and improve your daily routine

Time stamps

0:00 Intro
0:52 How to duplicate the sheet
1:05 resizing the columns
3:40 Title Formatting and merging cells
5:37 formatting Cells
6:08 Adding a border
7:23 Adding the checkboxes
8:04 Adding headers
9:03 formatting checkboxes
12:39 Adding a date and data validation
13:33 formatting the date
14:05 Days of the week
14:36 Explanation of the day of the week formula
17:32 Formatting the percentage bar
20:53 Adding habits and adding the icons
22:38 Explanation of countif formula
25:57 calculating the percentages
27:32 Count bar and sparkline
34:00 Percentage complete for month calculation
36:45 vertical bar graph sparkline for daily completion
37:22 Adding a area chart
39:09 Adding a doughnut chart

QUESTIONS
If you have any questions about this spreadsheet be sure to reach out to us on the store:

https://inhelpdesigns.weebly.com/#/
ABOUT ME
My name is JayJay, I have a background in Mathematics and spent most of my time creating new Google Sheets spreadsheets for my shop: InhelpDesigns. I try to design spreadsheets that are functional but minimalistic and aesthetically pleasing in design that will hopefully not only make keeping track of your business or personal finances a bit easier, but also more fun!

All of our spreadsheets are created for you, by you! After a year of selling spreadsheets, we decided to completely redesign our line, listening to everything our customers had asked for to create the ultimate line of personal finance and small business spreadsheets!

© InhelpDesigns

#habits #habittracker #googlesheets

Видео How to create your own Habit Tracker in Google Sheets - TUTORIAL канала InsightStackHQ