The Ultimate To-Do List Tracking Tool - Google Sheets

You know when you have to do regular recurring maintenance and you just can't remember the last time it was done? Well, that problem will be wiped out with this universal to-do list tracking tool that was built in Google Sheets.

$45.00 USD

The Google Sheet template will be immediately available to access after purchase. This is included in the HR templates and Accounting templates bundles as well.

to do list

The Excel version is also included in this purchase. It requires Office 365 and you may also need to be a part of Office Insiders program (free).

The upgraded version has a database so every time you complete a task, you enter the task name and the date it was completed. That data is then used to automatically fill out the most recent date something was completed and is also summarized in a monthly and annual view that shows the number of times a task was completed each month/year. This also has a visualization.

I built this tool in Google Sheets since anyone can use it if they have a free Gmail account. It is super simple and brain dead easy to grasp right from the start. This will handle lists of as little as a few things or as many as 500+.

All the formulas and conditional formatting are dynamic and will auto-update as you move through time.

Essentially, here is the logic (inputs and outputs).

Things you will enter (one time):
  1. Description of the task.
  2. If you are tracking it by days or months.
  3. The frequency (days/months) that you need to do/check the item.
  4. Every time you do the task, you will double click the date column and pick the date you performed the item on the list.
Resulting Outputs:
  1. The next check date or the next day that you need to do an action related to the task.
  2. The amount of days until you need to perform the given task.
I also made some dynamic filters so you can enter 'x' amount of days and this will list all the items on the to-do list that must be done within that amount of days or less. Also, I made a filter for the data that sorts it automatically by the amount of days until the item must be done. (nearest to furthest away).

Finally, I made a visual that shows a 3D bar graph of the list of items that need to be done against the amount of days until it must be done. This always pulls from the sorted data so it will go from nearest to furthest and automatically includes any new items.

So stay even more organized, this checklist template may also be of use for you.