I hope you are enjoying your Habit Tracker Bundle. I am excited that you want to try the Habit Tracker Spreadsheet, but I wanted to give you a few directions and tips on how to use the spreadsheet.
My main tip if you are not super familiar with Excel is to SAVE a copy of this spreadsheet before you start changing it. The two columns with gray headings contain formulas that you will not want to update or delete. The spreadsheet will not tell you if you have hit your goal if the formulas are messed up.
I have included a tab for both a Sunday start and Monday start. You will see both a sample tab and a blank tab for both Sunday start and Monday start.
1…Decide if you want your week to start on Sunday or Monday.
2…Make a copy of the blank sheet. Right click on “Monday Start Blank” tab and click “Move or Copy”. Check the box by “Create a Copy” and click OK. Rename the tab. I suggest naming it with the first day of the week. Example: April 8.
3…Type in the habits you want to track in column B. (See this post for habit ideas.)
4…Column K includes your “Success Criteria”. In this column type in the number of days per week you want to complete the task or habit. You may want to do certain habits every single day to really ingrain the habits. But there may be some habits you are OK completing less days per week. For example: If you are focusing on exercise, you may have one habit for “Daily Movement” and success may mean doing 10 minutes of daily movement every single day. You may also include “Cardio for 30 minutes” and success may be 5 days per week for a full 30 minutes. You may even have a weekly habit, so you would enter the success criteria as just “1”.
5…Do not touch the formulas in column J (Total Days Complete) and L (Success?)! If you accidentally mess something up and delete a formula, just copy the formula from a cell above or below or just go back to the blank tab and start over.
6…Start tracking your habits! When you complete your habit for the day, type X or x in the cell of the habit and day of the week. Both upper and lowercase X will allow the formula to do it’s work.
7…At the end of the week column K (Success?) will tell you whether or not you hit your goal.
I hope that explains how the spreadsheet works!