Work Log Instructional: Difference between revisions
Jump to navigation
Jump to search
(Created page with "Category:Flashy XM 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'!...") |
No edit summary |
||
| Line 1: | Line 1: | ||
To separate Work Log into contributors: | To separate Work Log into contributors: | ||
| Line 6: | Line 6: | ||
#type in =filter('Sorted'!A:D,'Sorted'!B:B="Name") into boz A1 in the spreadsheet. | #type in =filter('Sorted'!A:D,'Sorted'!B:B="Name") into boz A1 in the spreadsheet. | ||
That's it. | 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. | |||
[[Category:Flashy XM]] | |||
Revision as of 01:26, 1 September 2012
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.