Upgraded Continuous Flow Task Tracker with Apps Script (Google Sheets Only)
Вставка
- Опубліковано 23 лип 2024
- Let’s create an automated task tracker for a seamless experience. The automations require Apps Script. If you can't use apps script at work, the 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, this tracker is the way to go to be organized at work.
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.
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
Formulas/ Features Covered:
- Data Validation (Is Valid Date)
- Data Validation (Drop Down)
- Max
- Offset
- Iferror
- ISBLANK
- CountIFS
- Weekday
- Conditional Formatting
- Apps Script
- If statement
- Arrayformula
- Embeded formula in a header
- Rounddown
- Freeze Row
- Pivot Tables
- Pivot Table Groups
- Stacked Bar Charts
00:00 - Intro
00:11 - Tracker Overview
03:35 - Initial Set Up
05:40 - Creating the Automatic Counter
07:21 - Creating the Dropdowns
11:34 - Adding Conditional Formatting
12:42 - Popout Calendar & Additional Tabs
13:45 - Adding the Apps Script Code for the Automation
17:47 - Grouping Columns/Rows & Freezing Rows
18:28 - Embedding the Week Start Formula
20:38 - Adding the Completed Task Counter
22:25 - Creating the Pivot Tables
26:08 - Creating the Visualizations
This is amazing, I can finally track my tasks better. Thank you!
@@Swa-FroBeauty so glad you found it helpful! Happy tracking 😁
First! Updating my task tracker for the upcoming school year. Thank you! This was so helpful for my first year.
@@amandriabanks7583 amazing! So glad you found it helpful
Amazing, thanks!
@@ArthurMachadoMotta_SP so glad you like it!
Looks great - don’t suppose you can you share the sheet?
@@DeanB100AU there’s a full tutorial in the video if you’d like to build it or there’s a link in my bio for the template
Would you be able to make a video for Excel like this? I was trying to do it for my work, but it was a bit difficult to find the corresponding steps. Unfortunately, my works network doesn't allow google to be used. It's all microsoft.
Hey! You can find the most recent version of the excel alternative here! Apologies for it being vertical. I switched my filming style after this video to accommodate both platforms. ua-cam.com/video/_S3c81VQkvw/v-deo.htmlsi=oe9qJFd-jzVmeByV