How to Make a Checklist in Google Sheets | Add a Checkbox | Create a To-Do [Task] List

In this video, we will show you how to create a Google Sheets checklist.

To make a checklist, you can add checkboxes to cells in a spreadsheet. So let’s say, we want to create a checklist and are able to check-off each item in the task list when completed. So first, we will add boxes and use conditional formatting.

In this sheet, you can see a list of tasks present in column B here. Let’s first add checkboxes next to each and every task item here.

For that, let’s move to the insert menu here, and select the checkbox option. You can see the checkbox appearing in the selected cell here.

Let’s copy and paste the checkbox to other cells in the column. You can use the shortcut key Control C, while the cell is selected, to copy the checkbox. Now let’s select the remaining cells here and use Control V to paste the checkbox in each cell.

Now you can tick the checkbox next to each task item by clicking on it. Notice if unchecked, the value in the formula bar is False. If checked, the value becomes true. This will come in handy later.

Let’s use conditional formatting to make the checklist more interactive. So for example, when we check off a particular task, it should strikethrough automatically.

For that, we will use conditional formatting. So let’s select the task here, open up the format menu and click on conditional formatting.

Now let’s select the range for the formatting to cover all the tasks in the sheet. We will enter the starting cell reference, followed by a colon and then entering the last cell reference.

Next, we need to define the condition based on which formatting would be done. Let’s open the drop down menu here and select the Custom Formatting option.

Now we would be entering the formula based on which the formatting we select would be applied.

Let’s start with the equals to sign, followed by entering the cell reference where the checkbox is present. We basically want to apply the formatting if the checkbox is ticked, meaning if the value of this cell is True. So let’s enter an equals sign followed by typing in “TRUE”.

Next, let’s change the formatting style by clicking on the strikethrough option here and changing the color to grey.

Now when we tick on the checkbox, you can see that the formatting automatically changes.

That’s all!

❓💬 Would you like to know about any particular Google Sheets feature? Let us know in the comments below.

#HowTech #GoogleSheets
--------------------------------------------------------------------------------------------------------------

[loagengmaki]

The process was easy to follow through. Explanation was simple and concise. Now I understand, wonderful job.

[dianaf]

I love tutorials like these! Straight to the point, super practical, no fluff or unnecessary lenghty parts! Everything is carefully detailed! Amazing!!

[kalenstark]

the perfect video for what I needed to know. clear, concise, and presented in a way that I saw how I could expand on what I was wanting to do. thank you

[Lombardi]

Thank you for the tutorial. I needed this.

[Crystallluss]

Great video! Is there a way to sort the list to move completed tasks to the bottom, and incomplete to the top?

[virdanputrawan]

short, simple, great, very usefull. Thnaks

[gabenelson]

Can you make a checkbox popup for each cell? For example, say that for each cell there is a process of work to do. Can you make a checklist per cell so that the person can check off the work to be done for each cell?

[mayplsyrup]

if i'm making a rather large checklist, and I want to keep a fraction at the top (like 15/100) how would I do that so it's connected to the boxes I have checked

[brandonhowarth]

And Having a perfect fine

systems and fillout sheets to compare and make compatible checklists and

fineprint systems 2022+ >>>

[meaganheikal]

How do you create a checklist, but make the task move to a "completed" sheet in Google Sheets?