Step-by- Step Upgrade your Continuous Flow Task tracker with this step-by-step tutorial
Upgrade your Continuous Flow Tracker (V3) to turn your spreadsheet increase your organization even further.
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.
Upgrades:
Designated Parked Tasks tab to hold tasks you want to keep track of but aren’t going to work on right now
Designated recurring section
Include completed recurring tasks in the done tab
Updated automatic numbering
Updated week start formula on the done tab
Updated completed task counter
Updated task added timestamp trigger
00:00 - Intro
00:11 - Overview of Upgrades
00:40 - General Adjustments
01:15 - Automatic Counter
01:59 - Dropdown Options
02:18 - Adjust Apps Script
02:45 - Testing the Automation
04:14 - Week Start Formula
05:05 - Completed Task Counter
06:24 - How to Update the Tracker Each Week