83 reputation
5
bio website
location
age
visits member for 1 year, 9 months
seen Dec 13 '13 at 1:43

Nov
9
awarded  Benefactor
Nov
9
awarded  Scholar
Nov
9
accepted Sorting data in Google Spreadsheet by cell entry
Nov
7
comment Sorting data in Google Spreadsheet by cell entry
I need both views - by event and by student - available. There is a limit on the number of people per project, and since students work in groups, they want to see what other students' choices are.
Nov
4
comment Sorting data in Google Spreadsheet by cell entry
I've gotten closer using commands like =filter('By Event Name'!$A$3:$A$28;'By Event Name'!B$3:B$28=$B2) ("By Event Name" is the name of the first sheet) and then using conditional formatting to black out #N/A. This misses instances where a student has two entries in the same column in the first sheet.
Nov
3
awarded  Promoter
Nov
1
awarded  Student
Nov
1
awarded  Supporter
Nov
1
asked Sorting data in Google Spreadsheet by cell entry