Work Log Instructional: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
=Usage= | |||
To log tasks, click on Work Log and fill in all the fields. '''The link to the work product is the most important''', as it allows for evaluation. | |||
To separate Work Log | =Modification= | ||
To add new contributors to Work Log and to separate Work Log by contributors: | |||
#Create a new sheet | #Create a new sheet | ||
#Rename it with ''Name'', the name of the contributor | #Rename it with ''Name'', the name of the contributor | ||
Revision as of 01:27, 1 September 2012
Usage
To log tasks, click on Work Log and fill in all the fields. The link to the work product is the most important, as it allows for evaluation.
Modification
To add new contributors to Work Log and to separate Work Log by contributors:
- Create a new sheet
- Rename it with Name, the name of the contributor
- type in =filter('Sorted'!A:D,'Sorted'!B:B="Name") into boz A1 in the spreadsheet.
Status Log is sorted by =SORT( 'Status Log'!A2:Z ; 1 ; FALSE ) to produce the Sorted sheet.
That's it. Individual name sheet depends on the Sorted sheet having columns A through D, where the selector is the Name.