Select the C column, and go to Format, Conditional formatting, + Add another rule again. Now, let’s make the check mark green so it’s a bit clearer when a task is completed. Otherwise (not checked, thus FALSE) it will not. Now, whenever a checkbox is checked (TRUE), the task’s text will be strikethrough. Now, under Format style select black as the text color, white as the background color, click on the strikethrough symbol, and click on the Done button. In the box below it, fill in ’=C2:C=TRUE’. Also, select Custom formula under Format cells if…. Change the Apply to range part to B2:B1000, to make sure the header in B1 is not influenced.

A sidebar tool appears.Ĭlick + Add another rule. Now go to menu item Format, and then Conditional formatting. Select the whole B column by clicking on the B on top of it. Let’s use that first to make sure a task will be strikethrough when the checkbox next to it is marked, and thus completed. For that, Google Sheets has a nifty function called Conditional formatting. Ideally it is linked to a certain task, and both the task and checkbox’s styling should change based on whether the box is checked or not. Now a checkbox on itself doesn’t have much use. To make sure the whole of column C is populated with checkboxes, simply select C2, and drag the blue box at the bottom right of the cell all the way down.

Click one more time, and the check mark disappears again. When you click on the checkbox in C2, the box is checked. To add a checkbox to cell C2 select C2, and go to menu item Insert, and then Insert checkbox. First, we need checkboxes to add a check mark to tasks that have been completed.

We really only need two built-in features of Google Sheets to make this work. To make sure the header row is fixed and doesn’t disappear no matter how long your list of to-dos becomes, select the whole first row by clicking on the ‘1’ on the left, go to menu item View, Freeze, and select 1 row. Now, add the following headers to A1, B1, and C1: ‘Due date’, ‘Task’, ‘Done?’.

Todolist google