Forum Discussion
Filter table column by data validation error
What is the best way to filter table column data if data validation is applied with "warning" and the green error triangle appears for invalid entries?
A good way to start would be by being clear on what you're asking for. And I'm referring to your question here in this forum. Quite frankly, I think the reason you've had no replies despite over 30 views is that it's not even clear what kind of situation you're describing. It would help us help you if you would give us some more details, examples, that kind of thing... Even attach or post a copy of the spreadsheet--on OneDrive or Google Drive, just making sure there's no confidential info in it. And post a link here.
This is like the clearest question ever.
How do I filter on a column for rows that fail data validation?
I got here through google using that question.
So, is there a way to filter for rows with data validation errors?