Work Log Instructional
Jump to navigation
Jump to search
To separate Work Log into 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.