Original Task Tracker For Google Sheets- Full Overview & Tutorial
Let's build the original task tracker that started it all. If you can't use apps script at work, this non-automated version is perfect 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 first version of the task tracker:
V1- Original Task Tracker
V2- Upgraded Task Tracker with Automations
V3- Continuous Flow Task Tracker ( What I use at work now)
What we'll learn:
Add a popout calendar to select a date
Add Drop-downs
Create an automatic counter
Add a completed task counter
Add conditional formatting
Formulas Covered:
Data Validation
CountA
Sequence
CountIF
Conditional Formatting
00:00 - General Overview
01:17 - Calendar Pop out & Add Drop Downs
02:55 - Add Automatic Numbering & Completed Task Counter
03:49 - Add Conditional Formatting
04:53 - How to use & Update each week