Most individuals consider Google Sheets as an online app for creating and viewing spreadsheets for information evaluation, nevertheless it can be used for fundamental venture administration. While Sheets lacks the superior options of full-blown task-management software program, you’ll be able to create a spreadsheet to trace the progress you and your co-workers make on a staff venture.This information goes over the weather in Google Sheets that you should use to assist with venture monitoring. This consists of utilizing templates designed for venture administration, including dropdown menus with preset standing choices that you just and your co-workers can replace as duties are accomplished; and tagging co-workers to assign duties to them.1. Start with a venture administration templateGoogle Sheets consists of a number of templates for venture administration. You don’t have to make use of a template, after all, nevertheless it may give you a head begin on designing your spreadsheet. Then you’ll be able to customise it in accordance with your venture.From Google Sheets: At the highest of your Google Sheets house web page, you’ll see a “Start a new spreadsheet” header with a row of thumbnails beneath. These thumbnails are templates. Click Template gallery to the higher proper of the thumbnails, and also you’ll be taken to a full web page with template thumbnails.From Google Drive: On your Drive house web page, click on the New button at higher left. On the menu that seems, maintain your pointer over the arrow to the best of Google Sheets and choose From a template. You’ll see a web page with template thumbnails. Howard Wen / IDG
Save time by beginning with a venture administration template, then adapting it on your venture’s wants. (Click any picture on this story to enlarge it.)
On the “Template gallery” web page, scroll down till you see the “Project management” header. There are 4 templates to select from: Gantt chart, Project timeline, Project monitoring, and Event advertising and marketing timeline. Click a thumbnail to start out a brand new spreadsheet utilizing that template. The “Project tracking” template, for instance, consists of areas the place you’ll be able to monitor a number of levels of a venture. Within every venture or stage, you’ll be able to enter particular duties obligatory to finish the venture, together with a standing, precedence, begin and finish date, assignee, estimated hours, and extra for every process. Howard Wen / IDG
The Project monitoring template offers your staff a fast leg up on maintaining monitor of all of the duties to finish a venture.
Click anyplace within the spreadsheet to start out adjusting it on your personal venture. To change any textual content area: Simply choose it and begin typing.To change a date area: Type in a brand new date or double-click to deliver up a mini-calendar the place you’ll be able to choose a date.To choose a special choice from a dropdown record: Dropdown lists have a small down arrow to the best of the cell. Double-click the cell (or click on its down arrow) to see different choices to select from. Select one of many choices and it’ll seem within the cell. (More on dropdowns in a second.)To delete any columns or rows you don’t want: Select the column or row, right-click, and choose Delete column or Delete row. To add a column or row: Do the identical factor and choose Insert 1 column left, Insert 1 column proper, Insert 1 row above, or Insert 1 row beneath.In this fashion, you’ll be able to tweak the template to fit your venture completely.2. Create or customise dropdown listsYou can create a dropdown that lists particular numbers or phrases that you just’ve entered as preset decisions. Or, should you’re working from a template that already consists of dropdown lists, you’ll be able to add, edit, or take away choices in any dropdown.In a venture administration spreadsheet, it’s helpful to have a standing dropdown for every process, with choices resembling On Hold, Not Yet Started, In Progress, and Complete, as within the “Project tracking” template we checked out earlier. You can improve these dropdowns with background colours that denote standing at a look. Howard Wen / IDG
Dropdown lists present an effective way on your staff to trace the standing of assorted duties which are a part of a venture.
We gained’t go into all the main points of making a dropdown record from scratch right here. See our tutorial on utilizing dropdown lists in Google Sheets for full directions. Instead, we’ll deal with modifying an current dropdown record, together with including background colours.To edit a dropdown record: Click the small down arrow on the proper fringe of the cell that accommodates the record, then click on the pencil icon on the backside of the menu that seems. The “Data validation rules” sidebar opens to the best of your spreadsheet, displaying the foundations for this dropdown. Howard Wen / IDG
You can edit the choices that seem in a dropdown, or change their background colours.
Each choice that seems within the dropdown is in a separate textual content field within the sidebar. You can edit any merchandise by clicking it and typing in new textual content or numbers. To change the colour of an merchandise within the dropdown, click on the circle icon to its left and choose a shade.If the dropdown is one you created your self, you’ll be able to additional edit it by including extra choices or dragging-and-dropping the choices to reorder them. (See our dropdowns tutorial for particulars.) If you’re working with a dropdown that’s a part of a template, you’ll be able to’t add or rearrange choices.To take away a dropdown record from a cell: Click the small down arrow on the proper fringe of the cell that accommodates the record, then click on the pencil icon within the menu. At the underside of the “Data validation rules” sidebar, click on the Remove rule button.There’s heaps extra you are able to do with dropdowns that could possibly be helpful for venture administration, resembling making use of conditional formatting primarily based on values. For instance, you would assign a shade scale that ranges from crimson for a venture that’s 10% accomplished to inexperienced when it’s 100% accomplished. Our dropdowns tutorial has full directions.3. Tag individuals you’re working withTyping the @ image inside a cell in Google Sheets will open a panel that lists a couple of advised individuals in your contacts — or you’ll be able to kind the particular person’s title or e mail handle to drag them up. Click the particular person’s title, and it’ll be inserted into the cell as a wise chip. Howard Wen / IDG
You can assign a process to a co-worker by inserting a wise chip.
When you hover the pointer over this cell, a mini profile card for them will pop up. On it, you and others you’ve shared the spreadsheet with can click on icons to e mail this particular person, begin a textual content message or video chat with them, or add them to an occasion in your calendar.This is especially useful in a venture administration situation, as a result of you’ll be able to insert a co-worker’s sensible chip to assign a process to them. If different collaborators want to search out out extra details about that process, they’ll be capable of contact the assignee from straight inside the project-tracking spreadsheet.4. Share and collaborate on a venture administration spreadsheetYou can use a spreadsheet to trace your individual private initiatives, however the actual worth comes when a number of individuals are in a position to view and collaborate on a spreadsheet to collectively monitor a gaggle venture. To do this, you first must share the spreadsheet with them.When you’re viewing your spreadsheet, click on the Share button on the higher proper. Or, out of your Google Drive homepage, click on to focus on the spreadsheet that you just wish to share. Then, towards the higher proper, click on the Share icon (a head-and-shoulders silhouette with a +).Through both technique, a Share panel will open. Howard Wen / IDG
Sharing a spreadsheet with collaborators.
In the entry field, enter the e-mail addresses (or names in your Google Contacts) of the individuals with whom you wish to share. By default, the individuals you invite to your spreadsheet can edit it and reshare it with others.To change entry permissions on your invitees: Click Editor to the best of the entry field and select both Viewer or Commenter from the dropdown menu. Viewers can see all the information within the spreadsheet however can’t edit or touch upon it. Commenters can connect feedback to particular cells, however their feedback gained’t intrude together with your spreadsheet’s information.For a venture administration spreadsheet, you principally like do need some co-workers to have the ability to edit the spreadsheet — as an illustration, to alter the standing dropdowns as duties are accomplished and replace different fields with further info. But permitting anybody who views the spreadsheet to alter all features of it might result in chaos, so it’s smart to restrict Editor permissions to a small group of core collaborators after which assign anybody else both Viewer or Commenter permissions.The best strategy to assign completely different permission ranges to completely different teams of individuals is to ship completely different invites. First invite the individuals you wish to have Editor standing: add their names or e mail addresses within the entry field, kind a message to them, and click on Send. Next, click on the Share button once more, add a special group of names or e mail addresses within the entry field, change Editor to Viewer or Commenter, kind a message. and click on Send.To handle entry permissions at any time: When you’re viewing your spreadsheet, click on the Share button on the upper-right. Or, out of your Google Drive homepage, click on to focus on your spreadsheet and click on the silhouette headshot icon. the panel that opens lists all of the individuals who have entry to the spreadsheet. Click the down arrow to the best of any particular person’s title, and on the dropdown menu that opens, change their entry to Viewer, Commenter, Editor, or Remove entry. Howard Wen / IDG
Changing entry permissions for a Google Sheet.
For extra details about sharing on a spreadsheet, together with the right way to stop it from being downloaded, printed, or reshared, see our Google Sheets cheat sheet. And for particulars about collaborating on a spreadsheet, together with what it’s prefer to collaborate in actual time, see “How to collaborate on a document” in our Google Drive cheat sheet.
Copyright © 2023 IDG Communications, Inc.