project tracker

Google Sheets checkboxes evaluate to TRUE and FALSE, which makes counting completed tasks simple. Here’s how to count checked and unchecked boxes, add conditional totals, and scale your tracker with ARRAYFORMULA.