Do you struggle to keep track of your tasks with a simple list on a spreadsheet? Well, fret no more because I have just what you need: a variety of checklist and to-do list templates to cater to your specific needs.
In this article, I’ll introduce you to several checklist templates for Google Sheets and show you how to use them. Get ready to uncover secret tips for organizing your daily life and boosting your productivity!
Conditional Formatting
Each template comes with conditional formatting that automatically colors cells based on the status of each checkbox. For example, when you check a box, the corresponding cell turns gray. Some templates go even further by striking through the task name when the box is checked.
How to Make a Copy of the Template
If you’re using a desktop computer, simply click on the template link. You’ll be redirected to a page where you’ll find a blue button labeled “Use Template”. Click on it (you must be logged into Google) and you can start using the template.
If you prefer a more general method, open the spreadsheet and click on “File” in the top toolbar, then select “Make a Copy”. Give the copy a name and click “Make a Copy”.
Simple To-Do List Template (Simple Checklist)
This template is perfect if you’re looking for a simple and easy-to-use to-do list. Just enter your tasks in column B and check the corresponding boxes in column A once they’re completed. You can also add a due date (column C) or additional notes (column D).
When you check a box, the entire row turns gray and the task name is struck through. This allows you to easily visualize completed tasks and those that are still pending.
Automatic Checklist / To-Do List Template
This template works similarly to the simple template, but it automatically generates a list of unfinished tasks on the right side of the sheet. Just enter the task names in column B and check the boxes in column A when you’re done. When you check a box, the corresponding row turns gray and the task name is struck through.
In this template, you can also assign a number to each task to reorder them as needed.
Multiple Checklist / To-Do List Template
This template allows you to track up to 5 different checklists on a single sheet. Simply enter task names and check the corresponding boxes to the right of each task. The cells containing the task name and checkbox turn gray when you check the boxes.
Task List Template
This template is perfect for tracking repetitive or routine tasks. You can create a list of task names and use multiple columns of checkboxes for each task. For example, you can track complete or incomplete tasks for each day of the week. The cells containing the checkboxes turn gray when you check them.
About Checkboxes and How to Replace Them
When you check a box, the value in the corresponding cell becomes “TRUE”. If you uncheck the box, the value becomes “FALSE”. If you accidentally delete a checkbox, don’t panic! You can simply copy and paste another checkbox or use the “Insert” option in the toolbar to add a new one.
Google Sheets Task List Template from the Template Gallery
Google Sheets also offers a task list template directly in its template gallery. To access it, open a spreadsheet, click on “File” in the top toolbar, then select “New” and finally “From Template Gallery”. You’ll then see the “Task List” template.
Here’s an example of this template:
Now that you have access to a wide variety of checklist templates for Google Sheets, you can take control of your tasks and optimize your productivity!
This article was originally created by Corey Bustos of SpreadsheetClass.com. For more information and tips on Google Sheets, visit Crawlan.com.