Automatic Task Tracker Walk-Through (Google Sheets)
This task tracker has made me one of the most organized people in the company. It takes minimal time to upkeep and that amount is saved (plus more) by being more efficient with my tasks. I also never run the risk of of forgetting to do something.
There’s a full tutorial if you want to build it from scratch or you can buy a prebuilt template in my shop (link in bio).
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 task is added or status is marked at “Pending” or “Done”
Task automatically moved to the parked tasks list when status is updated to “parked”. You can move it back to the task list when the status is updated to “ready”.
Visualizations showing the breakdown of your task focus, priority, and task type by week as well as month.
There's a full tutorial at the end of the video if you'd like to build the tracker. You can also find a pre-built template in my store if you prefer to buy one already built. (Link in bio)