Kick off the new school year with lessons from our Back to School 2022 collection to help students express themselves, build relationships, and stay organized.

Add Links to Project Planning Resources

Playback Speed:
Transcript

In this extension, you will add links to resources in your project planning spreadsheet so they are organized and easily accessible to everyone in your group.

Adding links enables you to access a resource with just one click.

That way, you don’t have to search or ask others to find what you need.

To do this, you will: Use Google Sheets to add and organize links to your project’s resources that are stored online, such as documents stored in Google Drive.

To begin, open your project planning spreadsheet.

Next, add a column header at the far right for Links.

Make your header bold so it matches the other column headers.

Then, open a new tab in your browser.

Open your Google Drive.

Keep both tabs open while you complete this task.

First, locate the resource you want to link, then copy its address.

Then, return to your spreadsheet, and type in a description of the resource.

If necessary, resize the column to make it wider.

Now, highlight the resource description, and insert a hyperlink.

You can use the same steps to add links to resources from other sources on the internet, as long as there is a web address you can use.

Now you have links to resources and other project materials that you can easily access anytime.

Now, it’s your turn: Open your project planning spreadsheet and create a new column header for links, Open a new tab and go to your Google Drive, Copy resource link, And type a description for the resource and insert the link.

Choose an Extension
Add Links to Project Planning Resources

Add links to your project planning spreadsheet for your project’s resources.

Filter Tasks By Owner

Create a filter view in Google Sheets in order to clearly and easily see the tasks you own and keep track of which project steps you must complete.

Use Conditional Formatting to Show Task Status

Add conditional formatting to your project planning spreadsheet by selecting a range of cells to format, add and customize formatting rules, and choose colors that indicate task status.