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
On this page of the site you can watch the video online Original Task Tracker For Google Sheets- Full Overview & Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Sheets By Olan 26 March 2024, share the link with friends and acquaintances, this video has already been watched 901 times on youtube and it was liked by 12 viewers. Enjoy your viewing!
