Upgraded Custom Task Tracker with Automations in Google Sheets - Full Overview & Tutorial
Let’s add some automations and upgrades to the original task tracker. 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, check out my continuous flow task tracker as well.
This is the second version of this task tracker:
V1- Orignal Task Tracker
V2- Upgraded Task Tracker with Automations
V3- 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
Add slicers to view charts for specific time periods
Formulas/ Features Covered:
Data Validation (Is Valid Date)
Data Validation (Drop Down)
CountA
Sequence
Offset
Iferror
CountIF
Conditional Formatting
Apps Script
Pivot Tables
Charts
Slicers