I built a workbook in Excel then uploaded it to Google sheets. It includes cells with Data Validation using List with Dropdown. It works fine in Excel. In Google sheets, the dropdown shows the correct list of choices but when I select one I get the message "The data you entered in cell xx violates the data validation rules set on this cell." I have hundreds of cells with this DV rule and they all do the same thing.
The list is a named range Personnel that is on sheet List, and there are several sheets that use this rule.
I have not used Google sheets a lot so I am not sure how to share it for read-only to you, while allowing two other people to have full access. Here is the Excel version.
Bookmarks