SmartHelping / Task Tracking / Google Sheets
The Ultimate To-Do List Tracking Tool
Keep track of recurring maintenance, routine checks, and everyday tasks in Google Sheets. Set how often each task repeats, record when it was completed, and see the next due date and days remaining.
Immediate Google Sheets access after purchase. Excel version included. By purchasing, you agree to the Terms of Service.
Video walkthrough & spreadsheet preview
See how the tracker keeps recurring work organized.
Set up your recurring tasks
Define the schedule, then record each completion.
Use the tracker for a short list of recurring jobs or a larger list of 500+ items.
-
Describe the task
Enter the item you need to do or check, such as a maintenance task, routine inspection, or recurring administrative job.
-
Choose days or months
Select the interval type and enter how frequently the task needs to be completed.
-
Record when it was done
In the basic tracker, update the task's completion date each time you finish it. In Google Sheets, double-click the date cell to pick the date. The upgraded database workflow is described below.
-
Review what is coming due
The tracker calculates the next action date and days remaining. Use the filtered and sorted views to decide which tasks need your attention next.
Due dates, filters & visualizations
Bring the next tasks to the top of the list.
Next due date and days remaining
See the next date each task should be performed and the number of days until it is due. Formulas and conditional formatting update as time moves forward.
Choose your planning window
Enter a number of days to display the tasks due within that many days or less. Adjust the window to focus on the period you want to plan.
Automatically sorted priorities
Use the view that sorts tasks by days remaining, from the nearest due date to the furthest away.
Dynamic task chart
The 3D bar chart plots tasks against the days remaining until they are due. It uses the sorted data and automatically includes new items.
Upgraded version
Keep a history of completed tasks.
The upgraded version adds a completion database. Each time a task is finished, enter its name and completion date in the log. The tracker uses those entries to update its reporting.
Latest completion date
The most recent date for a task is filled in automatically from the completion log, so you can review when it was last performed.
Monthly and annual completion counts
Review how many times each task was completed by month and year, with a visualization of the completion history.
Recurring work made easier to follow
Know when it was done and when it is due again.
Keep the task description, repeat interval, and completion date together. The tracker turns those entries into a schedule you can review whenever you need to plan the next round of work.
Use it for recurring maintenance, routine checks, and other repeat tasks where remembering the last completion date matters.
More templates in one purchase
Explore the bundles that include this tracker.
Questions before you start
A few useful details.
Can I repeat tasks by days or months?
Yes. Select whether a task is tracked in days or months, then enter the repeat frequency.
How many items can I track?
The tracker is designed for lists ranging from a few items to 500+ tasks.
How do I record a completed task?
In the basic tracker, update the task's completion date. In the upgraded version, enter the task name and completion date in the database; the most recent completion date and history summaries are then populated from that log.
Can I see only tasks due soon?
Yes. Enter a number of days to filter for tasks due within that amount of time or less. A separate sorted view orders items from nearest to furthest due.
Is an Excel version included?
Yes. The purchase includes an Excel version as well as the Google Sheets template. The original Excel compatibility note specifies Office 365 and says the free Office Insiders program may also be required.
How do I access the tracker?
The Google Sheets template is available to access immediately after the $45 USD one-time purchase. An Excel version is also included.
Recurring task tracking
Keep the next due date in view.
The Ultimate To-Do List Tracking Tool — $45, one-time purchase.
