Sheets By Olan
Automated & Non-Automated Task Tracker (Google Sheets)
Automated & Non-Automated Task Tracker (Google Sheets)
Couldn't load pickup availability
Stay organized with this simple to use custom automated or non-automated task tracker!
Both the Automated and Non-Automated versions of the Google Sheets task tracker are included in this purchase. See below for the highlights of each:
***Save $$$ by purchasing these templates in the All Google Sheets Bundle! ***
Rolling Automated Task Tracker Features: (Full Walk-Through)
- Prioritization Dashboard
- Month Snapshot
- Recurring tasks are automatically added to your task list each day based on the day they need to be done
- Visualizations showing the breakdown of your task focus, priority, task type, and on time completion by week and month to easily see where you're spending your time
- Automatic timestamp when a task is added or marked as "Pending" or "Done"
- Dropdowns to keep track of your task type, progress/status, priority & task focus
- 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"
- 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
- Text formatting to easily identify which tasks are next
- Saved views for your table
- Completed task counter
- Easily updated and customizable
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 sorry 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.
Note: This tracker is for Google Sheets only. It is not transferrable to Excel.
*** While not common, some employers may not allow Apps Script due to company firewalls. If this is the case, the Non-Automated Task Tracker without Apps Script is a better option.
Improving your workday (and mental health) should be for everyone. If you cannot afford this item or want to make it yourself, I have a step-by-step training on my Youtube Channel @sheetsbyolan where I teach you how to make it from scratch. If you cannot afford it and are unable to make it from scratch just send me an email!
Share





