I have a spreadsheet test here.
My project is a bit long (1000+ rows) but I created something that works in a similar way.
My hypothetical situation:
I receive grades from my students via Google Forms and one question of this Google Forms the students are allowed to put more than one grade. A spreadsheet of these responses is created.
I receive these grades in a Sheet1 but inside of a Sheet2 I have a CUSTOMSPLIT() formula/script that separates each line from the Sheet1 that has more than one grade.
In Sheet2, I have a control system of each grade for each student. There is a data validation with the options CHECKED and REGISTERED. The option REGISTERED is automatically placed when there is a new answer from a student and the option CHECKED I put/chose whenever is necessary.
I can't link/arrange my data in alphabetical order in Sheet1 because the Sheet2 is be messed up. All the options CHECKED/REGISTERED from Sheet2 will be changed and will not follow the student/grade that I checked.
Anyone have any idea on how I can exit this problem?