https://dealsforwhiskytasting.blogspot.com/2022/09/spreadsheet-script-validation-data.html
Spreadsheet Script Validation: The Data Validation Rule Argument "=Employees!B1:B1000" Is Invalid