 |
| Google Sheets has a new feature that automatically creates a timeline from a spreadsheet that lists tasks. The timeline looks much like a Gantt chart you might find in project management software like Monday.com, Asana, or Microsoft Planner.
Have a look at this sample timeline for a student group research project proposal. To use the feature, at minimum your google sheet needs a task column and a dates column. In the sample, the following columns are included:
Tasks were grouped by the “Priority or Project” category and color-coded for each of the categories by adding a fill color to those cells. Once you have your sheet filled in, select insert > timeline, and you will see a new tab at the bottom of the spreadsheet that has the timeline mapped out. Under settings and optional fields, you can choose to show card color based on a column (“Priority or Project” in this example), what card detail you would like to view (“who” in this example), and how you would like to group your cards. |
