Forum Discussion
Updated data validation list not reflected in column filter
Hi. I wonder if anyone can help solve my problem? I have a "Staff member name" column as part of a large table. I use a data validation list to allow me to select the relevant name. I recently...
The filter drop-down only shows values that are currently present in the column. So if the new names haven't been selected yet, they will not be listed in the filter drop-down.
Thank you HansVogelaar , but that doesn't seem to be the answer.
I have recently added "Fiona" to the data validation list and added her in the final row, but hr name does not appear in the filter drop-down.
Is there something else I could try?
Thanks.
Are you sure that the new row is included in the filter range?
- That's done it. Thank you!
- Please verify if there are any hidden empty rows preceding the newly inserted line.
