How to Use Checkboxes to Create Dynamic Filtered Task Lists in Google Sheets

Tracking project deliverables, team action items, and personal to-do lists inside spreadsheets often leads to cluttered worksheets where completed tasks obscure pending priorities. Manually deleting finished rows disrupts historical audit logs, while applying strikethrough formatting across individual cells requires repetitive clicks and fails to reorder the list automatically.

Google Sheets includes native interactive checkboxes that output standard boolean values (TRUE or FALSE). When combined with dynamic array formulas like FILTER and SORT, checkboxes allow users to construct self-updating project dashboards where checking an item automatically transfers it to an archive tab or dynamically filters pending work in real time.

Inserting Interactive Checkboxes in Google Sheets

Adding interactive checkboxes to cell ranges in Google Sheets takes only a few clicks:

1. Open your spreadsheet in Google Sheets.
2. Highlight the cell range where you want checkboxes to appear (for example, column A2:A50).
3. Click the Insert menu in the top toolbar.
4. Select Checkbox.

Google Sheets populates each cell with a clickable square. By default, an unchecked box contains the boolean value FALSE, while a ticked box contains TRUE.

Building a Dynamic Filtered Pending Tasks View

Rather than manually hiding rows, you can use the FILTER function on a separate summary tab to display only tasks that remain incomplete:

1. Assume your master data sheet is named Tasks, where:
   • Column A contains the Checkbox (Status).
   • Column B contains the Task Description.
   • Column C contains the Assigned Owner.
   • Column D contains the Due Date.
2. Create a new sheet tab and label it Active Tasks.
3. In cell A2 of the Active Tasks sheet, enter the following dynamic array formula:

=FILTER(Tasks!B2:D, Tasks!A2:A = FALSE)

This formula evaluates column A on the master sheet and spills only the rows where the checkbox is unticked. The moment a team member ticks a box on the master sheet, that task instantly vanishes from the active view.

Creating an Automated Completed Archive

Similarly, you can track historical completions on a dedicated Archive tab without manual cut-and-paste routines:

=FILTER(Tasks!B2:D, Tasks!A2:A = TRUE)

Every completed task populates the archive sheet dynamically, preserving full records of delivered milestones.

Applying Conditional Formatting with Strikethrough

To provide immediate visual feedback on the master task sheet whenever a checkbox is marked:

1. Highlight the data range you wish to format (for example, B2:D50).
2. Click Format > Conditional formatting.
3. Under Format rules, click the dropdown menu and select Custom formula is.
4. Enter the following formula reference:

=$A2 = TRUE

5. Under Formatting style, click the Strikethrough icon and choose a subtle grey text colour.
6. Click Done.

Now, ticking any checkbox in column A immediately strikes out the corresponding task details across columns B through D.

Calculating Real-Time Project Completion Progress

You can monitor sprint completion rates by combining COUNTIF with COUNTA:

="Progress: " & TEXT(COUNTIF(A2:A, TRUE) / COUNTA(B2:B), "0.0%")

This formula calculates the exact percentage of completed tasks relative to the total number of recorded action items, providing an instant progress metric at the top of your sheet.