I have made a dependent drop down list which works as expected for my first two columns of options (in 'Schools' sheet) but for some reason does not work when selecting the third option of the initial list ('Cluster' column)
When I tried altering the headings of the two columns that worked (ARM and EPOS) they stopped working, despite being selectable in the inital 'Cluster' column under their altered names.
Googling and playing around has not availed me - any help very much appreciated. I've changed the names of the schools to random strings for confidentiality.
Annotation 2022-09-27 102032.png
Annotation 2022-09-27 102058.png
Annotation 2022-09-27 102116.png
Thank you!
Bookmarks