This To-Do List Task Tracker with Calendar Google Spreadsheet allows you to move tasks between sheets automatically when you change the status of a task using a drop-down.
Find out more on YouTube
You will also be able to visualise tasks on a fully dynamic Kanban board and a Calendar to visualise your tasks.
The Calendar allows you to choose any month and year to see your tasks over time; this allows for
better time management as it allows you to plan your tasks for days, weeks and months ahead. You can filter the tasks on the calendar to your liking, which allows you to drill down to what's important.
The Kanban board is the perfect way to get an overview of all your tasks for each status. Kanban boards allow you to plan your tasks out for short periods of time to ensure your workload is manageable for the next week or two. Plus, you can visualise your progress as you work through your list of tasks.
As tasks are created using a dedicated sidebar, a Google Docs document is automatically linked to a task with zero effort. This allows you to add comments, images, links and checklists or sub-tasks. Each task gets its own canvas to document everything you need and everything is conveniently saved in a dedicated folder in your Google Drive.
Tasks created with the sidebar will automatically appear in the relevant sheet you choose using a proven method of task management for task statuses: Backlog, Waiting, To Do, In Progress, Completed and Archived. Tasks are also automatically added to the Kanban board and the Calendar if a due date is set for the task.
If you like analytics, you'll also get to visualise your tasks with the built-in analytics to slice and dice your progress.
This template is powered by Google Apps Script, and everything is set up and ready to go; all you need to do is add your tasks! This sheet is designed to make task management effortless; adding and moving tasks is super easy and the automation speeds things up, which allows you to focus on getting things done.
Full instructions on how to get started are included with the download in a 13-page document which also includes best practices for using the sheet to get the maximum out of it.
Please note: This Google Sheet is not compatible with Microsoft Excel since it uses Google Apps Script to run the automation; plus, it also contains functions only found in Google Sheets, such as the QUERY function.
