This To-Do List with Calendar, Kanban & Timeline Gantt Chart in Google Sheets allows you to easily keep track of your tasks and visualise them on a built-in Calendar, Gantt Chart Timeline and Kanban style Task Board. This template can be used by individuals or teams alike. 
 
Please note, this template is not compatible with Excel. 
 
 The Kanban Task Board, Calendar and a Timeline Gantt Chart are fully dynamic and automatic, making managing your tasks a breeze. You can assign tasks to assignees, choose labels and group tasks into categories/projects. 
 
The Calendar allows you to choose any month and year to see your tasks for a selected month and year; this permits 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 Task 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. 
 
The Timeline Gantt Chart will automatically display the duration of tasks based on the start and end dates in your chosen project/category colour. As you mark tasks as Archived, the Gantt Chart will automatically update to hide past dates and show new dates at the end of the chart. You’ll never need to add new columns at the end, as the chart will constantly update as you progress through your tasks. You can also visualise your progress on each task with the mini progress bar chart and filter the tasks to drill down to view essential information.
 
This spreadsheet template is powered entirely by built-in Google functions and formulas. There is no Google Apps Script involved, which makes this a powerful yet lightweight tool. 
 
If you like analytics, you'll also get to visualise your tasks with the built-in Dashboard to slice and dice your progress.
 
This sheet is designed to make task management effortless; adding and keeping track of your 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 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 contains functions only found in Google Sheets, such as the QUERY function.