

You may not be able to open this file because it’s from an outside organization, and my Google Workspace domain is not whitelisted at your organization. I’ve set my file sharings to allow anyone with the link to view this file. How To Create A Google Sheets Checklist Template Checklist Templateįeel free to download the checklist template and make your own copy:įeel free to copy this sheet: File > Make a copy And I get almost as many questions about how I built these checklists as for the topic of the actual workshops. It ensures I don’t forget anything and gives the audience a visual clue as to where we’re up to in the workshop. When I teach live workshops, I often include a front sheet in my Google Sheet that I use as a checklist for the exercise steps. There are many situations when a checklist comes in handy.įrom simple to-do lists to project planners, from teaching lessons to tracking physical goods.Īnd although this simple spreadsheet checklist isn’t suitable for large, complex projects, or projects that require more robust data trails, it’s a quick and easy way to add some useful flair to your spreadsheet projects. We’ll use checkboxes, conditional formatting and a sparkline to build a checklist template like this:

In this tutorial, we’ll create a checklist template in Google Sheets.
