-
Create a spreadsheet with the name 'Grad jobs'
-
Insert cell data in the format shown below
-
(optional) Freeze columns A-G
-
Go to Tools -> Script editor
-
Create a new file called 'onEditHighlight.gs'
-
Copy the script
-
Create a trigger
- Fill out the details in Row A-G
- The Gantt chart will update when there is a change in the opening or closing dates
