top of page

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:

  • Project tasks

  • Marketing campaigns

  • Schedules

  • Cross-team collaborations

  • 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

  1. On your computer, at the top of your Sheets menu, click Insert Timeline.

  2. Select your date range.

  3. Click Ok.


Availability

  • 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




4 views
bottom of page