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, the 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 fourth and most recent version of this task tracker:
V1- Orignal Task Tracker (non-automated)
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
- Weekday
- Conditional Formatting
- Apps Script
- If statement
- Arrayformula
- Embeded formula in a header
- Rounddown
- Freeze Row
- Pivot Tables
- Pivot Table Groups
- Stacked Bar Charts
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