Google Sheets offers many of the same features as Microsoft Excel. The SUMIF function allows you to quickly sum rows that meet certain criteria.

You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.

Checkboxes and conditional formatting We really only need two built-in features of Google Sheets to make this work. First, we need checkboxes to add a check mark to tasks that have been completed.