To track and visualise tasks easier and faster, use 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
Eligibility
These Workspace editions can use timeline view:- Essentials
- Business Standard
- Business Plus
- Enterprise Essentials
- Enterprise Starter
- Enterprise Standard
- Enterprise Plus
- Education Fundamentals
- Education Standard
- Education Plus
- Business Starter
- Frontline
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 that your tasks last
Tip: Enter the amount of time either as a number of days or in hours, minutes, seconds format (hh:mm:ss).
- Include weekends: After you use Duration instead of End date, weekends are enabled. To remove weekends from the Duration, untick Include weekends.
Tip: For Start date and End date, the DATEVALUE formula can help ensure that the output is the correct value type.
Create a timeline view in your spreadsheet
- On your computer, at the top of your Sheets menu, click Insert
timeline.
- Select your data range.
- Click OK.
timeline.Tip: You can also select from the suggested data range.
Note: Now, you can view the timeline view experience on your Android or iOS mobile device.
Edit your timeline view
Edit your timeline view by column- On your computer in your created 'Timeline view' tab, click Settings
.
- Select the columns to use from the options below:
.Required fields:
- Card title: A name for each task.
- Data range: The data used to build the timeline view.
- Start date: Start dates in a date format.
- End date: End dates in a date format.
Tip: The start date for each task must be earlier than the end date. Otherwise, the card won't show a length. Learn how to troubleshoot cards that show only a single-day range.
Optional fields:
- Card colour: Card colour only appears in 'Timeline view' after you choose the column as the source of your card background. The colour of the column can be inherited from:
- Cell background colour that you applied manually to a column in your data.
- Conditional formatting of the column in your data.
Tip: You can also change a specific card background directly from the card in the 'Timeline view' tab. Learn how to edit your specific cards.
- Card detail: A description of each card.
- Card group: Group multiple cards on the same 'Timeline view' row based on a column.
- In the 'Timeline view', select the specific card that you want to edit.
- Tip: If you enter a URL in a cell in your selected range, a hyperlink is inserted automatically.
- In the bottom right of the Card details window, click Edit data.
- This opens the source data of your timeline view.
- Edit the selected row of the source data tab.
Important: Do not apply conditional formatting to the source data or you can't change the card colour.
- Select a card that you want to edit.
- Select an option:
- To change the background colour from a preset list, click Card colour and select a column from which the colour will be inherited.
Tip: Any colour changes made to the card in the timeline view will change as well in the source data.
- To change background colour with a colour spectrum, click Customise.
Important: In the card colour that you select, you can also use conditional formatting.
- At the bottom of your spreadsheet, select the tab that contains the timeline's source data.
- In your timeline's settings, click Card colour.
- Select a column from which the colour will be inherited.
- Change the background colour of the cells in the column. The card's new colour is updated in the 'Timeline view' tab.
Troubleshoot your timeline view
Card only shows an unexpected single-day range
If your card date range only shows a single day, this could be due to:
- Data isn't in an accepted date format.
- Start and end dates are the same.
Error messages
If you receive an error message for your timeline view, to fix your data and correctly display your timeline view, follow the error message's instructions.