38
2020 Habit Tracker Template (Free)
source link: https://docs.google.com/spreadsheets/d/1pGGjaMCYppJ6VWtxVBY40j6-6X299AGDufVqRtl-fQk/edit
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Here's how to use this Habit Tracker spreasheet:
1) Right click the "2020 Template" tab and select Copy to -> New spreadsheet to create your own editable version.
2) Fill in your goals on the first column rows
3) Every day you complete each of your habits, mark the corresponding day with an X and it will automatically fill it with color
CONFIG:
- Different Color: If you want to change the color for your squares just go to the top menu toolbar -> Format -> Conditional formatting and change the color of the existing rule.
- Different Color for each Habit: If you want to have different colors for different habits, follow the previous step and duplicate the rule, modifying the data range value as it corresponds.
That's it! Got any questions or suggestions? Contact me at [email protected]
1) Right click the "2020 Template" tab and select Copy to -> New spreadsheet to create your own editable version.
2) Fill in your goals on the first column rows
3) Every day you complete each of your habits, mark the corresponding day with an X and it will automatically fill it with color
CONFIG:
- Different Color: If you want to change the color for your squares just go to the top menu toolbar -> Format -> Conditional formatting and change the color of the existing rule.
- Different Color for each Habit: If you want to have different colors for different habits, follow the previous step and duplicate the rule, modifying the data range value as it corresponds.
That's it! Got any questions or suggestions? Contact me at [email protected]
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK