I have a new question and I don't how exactly to frame it, unless you can run and see.
I have been creating a form that will be used in more than one school,different grades to evaluate results. Each classroom has multiple teams. The initial set of questions are all about school, grade and evaluator and then the loop starts where each team scores get recorded.
Now on google sheets when I access the data, the looped information comes out on a different sheet.
So even as I select different schools and grades, that information shows up on sheet 1, but sheet 2 only has information starting from Team Name.
I.E - Sheet 1
Govt Model School ... Grade 5B ... ..... (lets say this has 2 teams)
Govt Primary School .... Grade 6B .....
Parent Link to Government Model School ... Team A - Score 1, Score 2, Score 3
Parent Link to Government Model School ... Team B - Score 1, Score 2, Score 3
Parent Link to Government Primary School ... Team A - Score 1, Score 2, Score 3
Parent Link to Government Primary School ... Team B - Score 1, Score 2, Score 3
I tried inserting the School Name and Grade labels so each team can have its corresponding school and grade name populating but of no avail.
How can I work around getting the School and Grade Information next to the looped set of Team Scores, and not just links so we can have the information together?
I am attaching both - the XLS file, and the Google Sheet where scores appear for any one to test here.
Looking for your advice / help .
- Tired Eyes