Скачать с ютуб Upgraded Continuous Flow Task Tracker with Apps Script (Google Sheets Only) в хорошем качестве

Upgraded Continuous Flow Task Tracker with Apps Script (Google Sheets Only)

NOTE: This is a great tutorial but it's not the most recent version. of the task tracker. See the Rolling Automated Task Tracker Tutorial instead if you'd like to see the most recent tracker. Stay organized with this simple to use custom automated or non-automated task tracker! Features: Automatic numbering Dropdowns to keep track of your task type, progress/status, priority & task focus Text formatting to easily identify which tasks are next Completed task counter Easily updated and customizable Automatic timestamp when a task is added or marked as "Pending" or "Done" -Task automatically moved to the Parked Tasks list when the status is updated to "Parked". This will allow you to keep an eye on tasks you need to keep on your radar but it wont clutter your task list. Marking the status as "Ready will automatically move the task back to your Task List Task automatically moved to a single lists of all completed tasks and is removed from the active task lists once the task is marked as "Done" Visualizations showing the breakdown of your task focus, priority, and task type by week and month to easily see where you're spending your time Make it your own by updating the color schemes and adding additional columns that would help your productivity. Note: This tracker is for Google Sheets only. It is not transferrable to Excel. *** While not common, some employers may not allow Apps Script due to company firewalls. If this is the case, the Non-Automated Task Tracker without Apps Script is a better option. 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