![]() Howard Wen / IDGĭropdown lists provide a great way for your team to track the status of various tasks that are part of a project. You can enhance these dropdowns with background colors that denote status at a glance. In a project management spreadsheet, it’s useful to have a status dropdown for each task, with options such as On Hold, Not Yet Started, In Progress, and Complete, as in the “Project tracking” template we looked at earlier. Or, if you’re working from a template that already includes dropdown lists, you can add, edit, or remove options in any dropdown. You can create a dropdown that lists specific numbers or words that you’ve entered as preset choices. In this way, you can tweak the template to suit your project perfectly. To add a column or row: Do the same thing and select Insert 1 column left, Insert 1 column right, Insert 1 row above, or Insert 1 row below. To delete any columns or rows you don’t need: Select the column or row, right-click, and select Delete column or Delete row. Select one of the options and it will appear in the cell. Double-click the cell (or click its down arrow) to see other options to choose from. To select a different option from a dropdown list: Dropdown lists have a small down arrow to the right of the cell. ![]() To change a date field: Type in a new date or double-click to bring up a mini-calendar where you can select a date. To change any text field: Simply select it and start typing. The Project tracking template gives your team a quick leg up on keeping track of all the tasks to complete a project.Ĭlick anywhere in the spreadsheet to start adjusting it for your own project. Within each project or stage, you can enter specific tasks necessary to complete the project, along with a status, priority, start and end date, assignee, estimated hours, and more for each task. The “Project tracking” template, for example, includes areas where you can track one or more stages of a project. Click a thumbnail to start a new spreadsheet using that template. There are four templates to choose from: Gantt chart, Project timeline, Project tracking, and Event marketing timeline. On the “Template gallery” page, scroll down until you see the “Project management” header. (Click any image in this story to enlarge it.) Save time by starting with a project management template, then adapting it for your project’s needs. ![]() You’ll see a page with template thumbnails. On the menu that appears, hold your pointer over the arrow to the right of Google Sheets and select From a template. Click Template gallery to the upper right of the thumbnails, and you’ll be taken to a full page with template thumbnails.įrom Google Drive: On your Drive home page, click the New button at upper left. From Google Sheets: At the top of your Google Sheets home page, you’ll see a “Start a new spreadsheet” header with a row of thumbnails underneath. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |