Skip to product information
1 of 12

Sheets By Olan

Automated & Non- Automated Task Trackers (Excel & Google Sheets)

Automated & Non- Automated Task Trackers (Excel & Google Sheets)

Regular price $12.99 USD
Regular price $19.98 USD Sale price $12.99 USD
Sale Sold out
Shipping calculated at checkout.
  • 5 stars: 2 (67%)
  • 4 stars: 0 (0%)
  • 3 stars: 0 (0%)
  • 2 stars: 0 (0%)
  • 1 star: 1 (33%)
K
Kirsten

Bought this from Olan back in January 2026 and I LOVE IT. It's made it extremely easy to report up to my manager what I'm working on and what I have accomplished. It has also made mid-year reviews easy to compile my accomplishment for the year so fat. The YouTube tutorial on how to set it up the Excel version and how to customize it a bit more were easy to follow for me, but I already had a great familiarity with Excel.

The next automated workbook I'm hoping will pop up one day is an automated project tracker.

I'm so glad you've found the template beneficial and it's made your mid-year reviews a breeze, Kirsten! That's exactly the experience I'm hoping for. Noted on the automated project tracker. I get this request often so I'll try to prioritize it. Let me know if there are any specific must have features you're looking for.

A
Anonymous

To complicated to set up I thought I was buying the finished product ,I dont have time to learn excel that's why I bought this but just a basic sheet I could make

Hi Ross! I hate to hear that you had trouble adding your specific task details. It's definitely a finished product. You just have to add your specific task details to finish it up. I wish you reached out to me to help troubleshoot! Following up with you via email now to see exactly where you had trouble.

K
Kendra

Exactly as promised and no issues so far. I have not had to reach out but I have seen he is very supportive in comments if anyone has issues.

Can't decide which Automated Task Tracker will work best for you? Why not get both and decide as you start working with them?

Here's is a video showing side by side comparisons between the two.

Google Sheets:

Customizable Automated Task Tracker: (Full Walk-Through) *** NEW***

Launched August 2026!

  • Task automatically moved to a single lists of all completed tasks and is removed from the active task lists once the task is marked as "Done"
  • Automatic timestamp when a task is added or marked as "Pending" or "Done"
  • Task automatically moved to the Parked Tasks list when the status is updated to "Parked". This will allow you to keep an eye on tasks you need to keep on your radar but it wont clutter your task list. Marking the status as "Ready will automatically move the task back to your Task List
  • Dropdowns to keep track of your task type, progress/status, priority & task focus
  • Recurring tasks can now repeat by an exact day of the month (like the 5th, or the last day of the month) in addition to weekday-based rules like "First Monday" - fits how your job actually schedules things
  • Guided timezone & schedule setup walks you through confirming your timezone and picking exactly which days and times trigger your Daily tasks 
  • Set a "Days to Complete" countdown on any recurring task and its Deadline gets calculated automatically the moment it's added to your list
  • Task Bundles: build a reusable, one-click group of tasks (like a New Hire checklist) and add the whole thing to your task list instantly from its own menu - run it as many times as you need
  • Rename or reorder your column headers and the automation still finds them - you're not locked into a fixed layout
  • One click ("Sync Columns Across Tabs") keeps Parked and Done matching Task List whenever you add, remove, or rename a column - no manual rebuilding
  • Pause every automation at once with a single Resume Date - perfect for vacation, nothing fires until you're back
  • Update your Priority or Progress dropdown options in one place and every tab (plus the sort order) updates with them
  • Overdue deadlines highlight in red automatically - no manual refresh, no trigger needed
  • Links pasted into Website keep their preview card even after a task is automatically moved or added
  • This will be the version that receives future upgrades!

Note: This currently excludes the calendar snapshot, kanban view, and charts. These will be added soon.

    Non-Automated Task Tracker Features: (Full Walk-Through)

    The non-automated version has essentially the same features as the automated version except for the automatic timestamps and automatically moving from tab to tab. There is also no parked tab. Otherwise it works the same. Don't worry though, it requires minimal upkeep to operate and super easy to use!

    Make it your own by updating the color schemes and adding additional columns that would help your productivity.


    Excel:

    Automatic Task Tracker Features:  (Full Walk-Through)

    Launched January 2026

    • Quickly add recurring tasks to your task list with one click
    • Dashboard with a calendar snapshot as well as a prioritization list for pending tasks
    • Kanban view
    • Dashboard with a calendar snapshot as well as a prioritization list for pending tasks
    • Automatic timestamp when a task is marked as "Not Started", "Pending", or "Done"
    • Task automatically moved to a single lists of all completed tasks and is removed from the active task lists once the task is marked as "Done"
    • Visualizations showing the breakdown your task focus, priority, task type, and on time completion by week and month to easily see where you're spending your time
    • Task Automatically moves to the "Parked" tab when the status is marked as "Parked" to keep track of it separate from your task list.
    • Task automatically moved from the "Parked" tab back to the "Task List" tab when the status is marked as "Ready"
    • Drop-downs to keep track of your task type, progress/status, priority & task focus
    • Text formatting to easily identify which tasks are next
    • Completed task counter
    • Easily updated and customizable

    Non-Automated Task Tracker Features: (How to use)

      The non-automated version has essentially the same features as the automated version except for the automatic timestamps and automatically moving from tab to tab. There is also no parked tab. Otherwise it works the same. Don't worry though, it requires minimal upkeep to operate and super easy to use!

       

      View full details