Upgraded Continuous Flow Task Tracker with Apps Script (Google Sheets Only)

Stay organized with this simple to use custom automated or non-automated task tracker!

Features:

Automatic numbering

Dropdowns 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

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

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 of your task focus, priority, and task type by week and month to easily see where you're spending your time


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.

00:00 - Intro
00:11 - Tracker Overview
03:35 - Initial Set Up
05:40 - Creating the Automatic Counter
07:21 - Creating the Dropdowns
11:34 - Adding Conditional Formatting
12:42 - Popout Calendar & Additional Tabs
13:45 - Adding the Apps Script Code for the Automation
17:47 - Grouping Columns/Rows & Freezing Rows
18:28 - Embedding the Week Start Formula
20:38 - Adding the Completed Task Counter
22:25 - Creating the Pivot Tables
26:08 - Creating the Visualizations