You are a project manager with a universe upon your shoulder. You want to collaborate tasks easily on GSuite just because you subscribed. What do you do? Answer: Create a Gantt Chart Google Sheets template.

Below is a simple action plan:

Create a Timeline Template or Gantt Chart in Google Sheets. You can change the dates so that they do not overlap and are more of a Gantt Chart than a project timeline template.

Assign task owners

Share the template with all task owners as Viewers or Editors

  • File menu > Share
  • In the window that appears, you can set whether “Viewers and commenters can see the option to download, print, and copy” from the top right’s gear icon.
  • Add people and groups. You can assign them as Editor, Viewer or Commenter. Check to notify people. Enter a brief message. Click Send.
  • In “Get link” section, you can also share document link and grant restricted permission. That is, only people added can open the link. This is another way to share the document.

Notification

Ask everyone to set notification settings to receive updates to project timeline.

  • Tools menu > Notification rules.
  • Select “Notify you when: Any changes are made” in most cases
  • Subsequently, select either Email – daily digest or Email – right away to send an email for every change.

As soon as someone shoots you an email on changes in project delivery date, work it out on the template.

Sharing Document Access Rights

In Google Groups click on Create Group. Set the group name, group email address, language preference etc.

Send invite to project team to join the group. People in the same group have the same document access. Once they leave the group, they lose that access right.

Share setting for Gannt Chart Google Sheets

Lock Critical Content

Open Project Timeline Template or Gantt Chart Google Sheets.

You can dictate who has the authority to edit certain ranges.

Go to Data > Protected sheets and ranges

Click “Set permission”.

You then have the option to “Restrict who can edit this range” and “Show a warning when editing this range”.

Assign Task in Gantt Chart in Google Sheets

In Google Sheets, you can click insert comments in cells (Insert > Comment). You then put a plus sign (+) followed by a person’s email address. By checking the “Assign to …” checkbox, this will assign the task to that person. The person will get a link to the file and an email notification. You can even add multiple people.

Assign task to task owner in Google Sheets dialogue box

Present Project Plan Online

For remote teams, use Google Meet to host online meetings. You can access Google Meet directly from Gmail or Google Calendar interface.

Google Meet allows you to share your screen so that you can resent your project plan remotely.

View and Edit the Task On the Go

In Google Play store or App Store, find and install Google Sheets app.

This will allow you to view and edit Google Sheets on the go.

Gantt Chart Google Sheets Features

You can download a free Timeline Template Google Docs where dates will naturally expand as you put in start and end dates.

Alternatively, you can buy an improved version built on top of that, which will allow you to:

  • Set Task Mode as either Done, Cancelled, In Progress or Not Started
  • See task owners by picture
  • Easily insert comments on tasks. Select the task, go to Insert menu > Comment (shortcut Ctrl+Alt+M)
  • Edit Duration to control task end date
  • Calendar dates in row 6 expand and shrink according to Start and End date

and more features to come.

Gannt Chart in Google Sheets

Once you purchase the product, you will enjoy lifetime access to the document and all the upgrades that come with it.

This Gantt Chart Template Google Sheets product is free for the moment as more features are being added. Not for long though.

If you want a link to the product, put in comment below on what you would like to change on the product to make it fit your purpose. I will send you a link to copy the sheet in 48 hours.

Note that the system will check the validity of the email and so will take longer to jump to next page.

Gantt Chart Google Sheets as a Collaboration Tool

As shown, GSuite offers many features that will satisfy the regulation of access rights, sharing of contents, assignment of tasks and so on.

While it is certainly in no way as powerful as Microsoft Project, it could be a no brainer for teams already on GSuite for Business for a simple team project.

Pin It on Pinterest

Share This