Hi, hope all are keeping well.
I’m making a list containing details of some of my students regarding their test results.
Certain tests determine the students’ development of skills in the following areas: “Stamina”, “Speed” & “Technique”, which are graded using drop down options “Lvl. 1”, “Lvl. 2” & “Lvl 3”.
I want to set up the sheet so that when “yes” is present in the “passed test” column these drop down options are selected/filled automatically at the correct “level”- if the test determines skills at a certain, graded level, and the student has passed it, I don’t want to have to fill out details of the skill grades said test represents; it could and should be done automatically.
Here is an illustrative example doc:
Student test results example.ods
Edit: I know I could achieve a similar result using IF formulae in the “Stamina”, “Speed” and “Technique” columns in lieu of drop down lists, however I’m curious as to whether it can be done this way, as there are advantages to this approach.