I just worked through a process where
Mr. Gosse, Chemistry teacher, wanted students to sign up for research topics. He created a Google Sheet that will be shared with students. He added formulas to the right side of the sheet so that the topics are crossed out when a student adds their name.
Because the entire sheet needs to be shared with students in an editing mode, he wanted to know if certain cells (the topics on the right side) could be protected.
They can.
Students will now choose their topic and add their name all within the
Google Sheets app on their iPad.