I have a spreadsheet, with this linking all the subsheets to a "main" sheet.
=QUERY({
IMPORTRANGE("https://docs.google.com/spreadsheets/d/<id>/edit", "custom!A:E");
IMPORTRANGE("https://docs.google.com/spreadsheets/d/<id>/edit", "hebrew!A:E");
IMPORTRANGE("https://docs.google.com/spreadsheets/d/<id>/edit", "sanskrit!A:E");
IMPORTRANGE("https://docs.google.com/spreadsheets/d/<id>/edit", "arabic!A:E");
IMPORTRANGE("https://docs.google.com/spreadsheets/d/<id>/edit", "swahili!A:E");
IMPORTRANGE("https://docs.google.com/spreadsheets/d/<id>/edit", "tibetan!A:E");
IMPORTRANGE("https://docs.google.com/spreadsheets/d/<id>/edit", "chinese!A:E");
IMPORTRANGE("https://docs.google.com/spreadsheets/d/<id>/edit", "inuktitut!A:E")
}, "select Col1, Col2, Col3, Col4, Col5 where Col2 is not Null order by Col2")
It is showing validation errors properly, but only in the main sheet (not in the subsheets).
In addition to showing the "master" list with everything (which makes it easy to check for validation errors), I would like for the validation error to propagate back into the subsheets. This is because I work directly on the subsheets, not the master sheet. I want to know when I am editing a subsheet if I have encountered a validation error globally (without having to switch back and forth to the main sheet whenever I add a new row). So I would like the validation error to show up in the column with the error, in the subsheet.
How can I accomplish that?
Notice "pasal" in the image is highlighted. In the main sheet, it shows the validation error, in the subsheet (hebrew) it does not. I want it to show in both sheets somehow. If it's not possible, please explain why. If it is possible, just outline the general approach for me so I can figure out the code (or if you know what commands/code to add, that would be great too).