I am a teacher, and keep grades and notes for multiple students in a single spreadsheet. Each student has one row with 6 cells. I would like to share each student’s row only with his parents and homeroom teacher.
Is there a way to set it up so that any given student’s parent and homeroom teacher can see only his or her cells? This would be for viewing only, not editing.
I am using Google Spreadsheets.