Data Validation disappears with ISNUMBER formula

Copper Contributor

I am working on a spreadsheet that has multiple tables in one page. I have manually validated each table using the formulas similar to this




The spreadsheet was tested multiple times by myself and different users. When this was sent to business users, they could not input any number at all and get the error message that there was a data validation in place.


I went back to the original spreadsheet that was sent to them and I am now getting the same error message also.


I am very confused about this because I have tested this and manually validated each table.


EDIT: bearing in mind, this formula and data validation works across other worksheets. The cells in this worksheet definitely do not have protected cells.

1 Reply


Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?