Continuous Flow Task Tracker with Apps Script- Full Overview & Tutorial (Google Sheets)
Let’s create an automated task tracker for a seamless experience. The automations require Apps Script. If you can't use apps script at work, this non-automated version is a better fit for you to get organized at work. If you have the ability to use Apps Script as work, this tracker is the way to go to be organized at work.
This is the third version of this task tracker:
V1- Orignal Task Tracker
V2- Upgraded Task Tracker with Automations
V3- Continuous Flow Task Tracker
V4- Upgraded Continuous Flow Task Tracker (What I use at work now)
Note: Apps Script is not transferrable to Excel. If you want to find an automated Excel version, see my video for the Continuous Flow Task Tracker with VBA in Excel.
What we'll learn:
Set up column headers
Add a popout calendar to select a date
Add Drop-downs
Create an automatic counter
Add a completed task counter
Add conditional formatting
Add automatic timestamps for status updates
Create pivot tables
Create visualizations of completed tasks
Formulas/ Features Covered:
Data Validation (Is Valid Date)
Data Validation (Drop Down)
Max
Offset
Iferror
ISBLANK
CountIFS
Conditional Formatting
Apps Script
If statement
Arrayformula
Embeded formula in a header
Freeze Row
Pivot Tables
Pivot Table Groups
Stacked Bar Charts
00:00 - Overview
01:50 - Initial Set Up
04:15 - Creating the Dropdowns
06:48 - Creating the Automatic Counter
08:45 - Adding Conditional Formatting
09:50 - Adding the Apps Script Code for the Automation
11:42 - Embedding the Week Start Formula
13:53 - Adding the Completed Task Counter
15:00 - Creating the Pivot Tables
18:04 - Creating the Visualizations
23:53 - How to Use the Tracker
25:02 - Update the Tracker Each Week