Card group: Group multiple cards on the same Timeline View row based on a column.Card detail: A description of each card.Tip: You can also change a specific card background directly from the card in the Timeline View tab. Conditional formatting of the column in your data.Cell background color you applied manually to a column in your data.The color of the column can be inherited from: Card color: Card color only appears in Timeline View after you choose the column as the source of your card background.Learn how to troubleshoot cards that show only a single day range. Tip: The start date for each task must be earlier than the end date. Start date: Start dates in a date format.Data range: The data used to build the Timeline View.Select the columns to use from the options below:.On your computer in your created Timeline View tab, click Settings. To create a timeline in Google Slides, select the 'insert' menu and then choose the 'diagram' option.Tip: For Start date and End date, the DATEVALUE formula can help ensure the output is the correct value type.Ĭreate a Timeline View in your spreadsheet To remove weekends from the Duration, uncheck Include weekends. Include weekends: After you use Duration instead of End date, weekends are enabled.Tip: Enter the amount of time either as a number of days or in hours, minutes, seconds format (hh:mm:ss). Duration: The amount of time your tasks lasts.You can even create a fun roadmap Google Slide. To create a complete Timeline View, you should include separate columns for: The Timeline Google Slides Template provides 15 creative timeline templates with amazing quality. 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.

Timeline template google slides