I want to ask the language level taught in several languages. However, no teacher teaches ALL these languages. If I make this question obligatory, and only fill in the grid for English and Spanish, I get an error report.
Unfortunately, if you make a grid type question REQUIRED then a response must be entered for each row.
You might want to consider adding a NONE column to your question and making it the default response.
I am curious – your posting mentions columns. However, the rows within a grid constitute the sub-questions, so the grid as configured is asking about what languages are taught at the different levels. Is that your intent?
You can review the following documentation as well:
I’m with Jim – it seems that you need to swap your columns and rows to get the data that you are asking for (grids are row based rather than column based).
I hope this helps!