top of page

Use formatting to easily scan your progress

Updated: May 15

If you're using checklists of any kind, chances are they have a number of steps with different dates and times that things will be completed.

Keeping track of your progress can be a tedious process if you have to keep checking which lines are or are not completed. If you use built-in tools like conditional formatting and formulas in your checklists, your processing can be dramatically simplified.

In Google Sheets use this style of formula:

A screenshot of a Google Sheets screen that shows the COUNTA function

The "COUNTA" function finds any entries that have something in them, and the ROWS function counts the total number of rows in the range. So if you have 10 entries in 20 rows, that 10/20 will be .5 or 50%, depending on how you format the cell.

Once you have your cell formula for the range of checklist items, just add some conditional formatting to them based on their value:

A screenshot of two Google Sheets cells with the red cell indicating "8%" and a yellow cell indicating "17%"

Google Sheets will automatically color the cells based on whatever criteria you choose. Conditional formatting does the work so as long as you're not colorblind, just look for green across the top of your checklists.

A screenshot of Google Sheets' conditional formatting options

That's how you'll know if you're current. You don't even need to read the numbers as long as green indicates 100% complete.

Let the colors and the formulas keep track of progress - this will make it simple to scan and review which items need attention.

A screenshot of Google Sheets cells indicating varying percentages that are color-coded

More info here: Google Support


bottom of page