Work Log Instructional

From Open Source Ecology
Revision as of 01:26, 1 September 2012 by Marcin (talk | contribs)
Jump to navigation Jump to search


To separate Work Log into contributors:

  1. Create a new sheet
  2. Rename it with Name, the name of the contributor
  3. 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.