You can now create timelines/Gantt charts with a few clicks in Google Sheets. For best results, first set up your data, and then create your timeline:

Make a copy of this demo Google Sheet to follow along: [ Ссылка ]

0:00 Intro
0:16 Required fields for Timeline
0:48 Set up Dates
1:29 Set up Duration
2:16 Create drop-down menus for repeated values (data validation)
3:30 Create Timeline
3:50 Adjust Timeline
4:50 End date vs. Duration
4:31 Optional settings (card details, grouping, color)
5:49 Color cards by conditional formatting
7:24 View options
7:49 View card details and Edit data

Timelines are available only in some Workspace Accounts - see more here: [ Ссылка ]

Slides: [ Ссылка ]

свернуть