Pro To-Do List Tracker - Recurring
![pro to do list tracker recurring 1]()
![pro to do list tracker recurring 2]()
![pro to do list tracker recurring 3]()
![pro to do list tracker recurring 4]()
![pro to do list tracker recurring 5]()
Recently updated to included database for tracking all completed tasks.
Video Overview:
Along with the Google Sheets version, an Excel version is also included in the download. The Excel version requires Office 365 and you may also need to be apart of Office Insiders program (free).
This is built in google sheets. Upon purchase, you will be taken to a word doc that contains the google sheet link. You need a free google account to gain access to that link. Once you do, go to File > Make a Copy to have your own editable version of this template.
This tool was designed for any individual or business that has recurring to-do items and needs to track the last time something was done as well as see in how many days a given item will need to be done again. This could be used for all kinds of things such as home maintenance, car maintenance, or regular purchases that must be made. For businesses, it could be used for important deadlines in relation to taxes or literally anything that must to be done at some regular interval.
The primary data input tab lets the user enter the description of the item, the amount of time that should be in-between doing the thing on the list, and finally the date column for when you last did the item. So, every time you do something, just enter the date. Validation was used so a calendar will come up if you double click the date column cells.
The output will show the user how many days until an item on the to-do list needs done as well as color coding depending on how close it is to needing to be done. You can adjust the amount of days that trigger each color (red/yellow/green).
A few filters were added. The first is a different tab where the user enters a day amount and the formula will show all items that need to be done within that many days. The second filter tab shows all items and ranks them in order from nearest to latest in terms of when the next time is that a thing needs to be done.
I also added a visual chart to this that shows the total length of time until something needs done per item in a 3D bar chart.
Enjoy!
Video Overview:
Along with the Google Sheets version, an Excel version is also included in the download. The Excel version requires Office 365 and you may also need to be apart of Office Insiders program (free).
This is built in google sheets. Upon purchase, you will be taken to a word doc that contains the google sheet link. You need a free google account to gain access to that link. Once you do, go to File > Make a Copy to have your own editable version of this template.
This tool was designed for any individual or business that has recurring to-do items and needs to track the last time something was done as well as see in how many days a given item will need to be done again. This could be used for all kinds of things such as home maintenance, car maintenance, or regular purchases that must be made. For businesses, it could be used for important deadlines in relation to taxes or literally anything that must to be done at some regular interval.
The primary data input tab lets the user enter the description of the item, the amount of time that should be in-between doing the thing on the list, and finally the date column for when you last did the item. So, every time you do something, just enter the date. Validation was used so a calendar will come up if you double click the date column cells.
The output will show the user how many days until an item on the to-do list needs done as well as color coding depending on how close it is to needing to be done. You can adjust the amount of days that trigger each color (red/yellow/green).
A few filters were added. The first is a different tab where the user enters a day amount and the formula will show all items that need to be done within that many days. The second filter tab shows all items and ranks them in order from nearest to latest in terms of when the next time is that a thing needs to be done.
I also added a visual chart to this that shows the total length of time until something needs done per item in a 3D bar chart.
Enjoy!
