Manage projects & tasks with a new timeline view on Google Sheets
Google Tasks is a simple to-do list—but with lists, subtasks, and mobile notifications, it has the basics you need to stay productive and keep track of the most important things you need to do. And with Zapier, you can do even more with Google Tasks.
Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs Editors suite offered by Google. The service also includes Google Docs, Google Slides, Google Tasks, Google Forms, Google Sites, and Google Keep.
Create & edit a Timeline View
Timeline View is an interactive visual layer in Sheets that can help you manage many project parts, such as:
Any future plans
To extend the power of smart canvas, we’re introducing an interactive timeline view that allows you to track projects in Google Sheets. This new visual layer displays project information stored in Sheets, such as the task start and end date, description, and owner.
Prepare your data
Important: To create a Timeline, you must have at least one column of data in date format. If you're using formulas in the date columns, the output should be date values. To create a complete Timeline View, you should include separate columns for:
Card title: A name for each task
Start date: Start dates in a date format
End date: End dates in a date format
Card detail: A summary of each task
Duration: The amount of time your tasks lasts
Create a Timeline View in your spreadsheet
On your computer, at the top of your Sheets menu, click Insert Timeline.
Select your date range.
Available to Google Workspace Essentials, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, the Teaching and Learning Upgrade, and Nonprofits customers
Not available to legacy G Suite Basic and Business customers
Not available to users with personal Google Accounts