This Project Management Template with Calendar, Kanban Board and Timeline Gantt Chart in Google Sheets allows you to move tasks between sheets automatically when you change the status of a task using a drop-down. It can be used by individuals or teams alike. 
 
You will also be able to visualise tasks on a fully dynamic Kanban Task Board, a Calendar and a Timeline Gantt Chart to visualise your tasks over time. 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 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 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.
 
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, Calendar, Timeline and Dashboard.
 
If you like analytics, you'll also get to visualise your tasks with the built-in Dashboard 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 17-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.