Step-by- Step Upgrade your Continuous Flow Task tracker with this step-by-step tutorial

Publié le: 06 juillet 2024
sur la chaîne: Sheets By Olan
996
like

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


Sur cette page du site, vous pouvez voir la vidéo en ligne Step-by- Step Upgrade your Continuous Flow Task tracker with this step-by-step tutorial durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Sheets By Olan 06 juillet 2024, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 996 fois et il a aimé like téléspectateurs. Bon visionnage!