Hey all,
I’m using lookup columns to validate data pulled in from an external user submitted tool, and need a way to check for errors. Obviously the little red arrow appears, but is there a way to filter and show only cells that have errors? (In Google Sheets, isError().
In this case, this user input his name as Jonathan, not Jon, which he usually does.
**Note - i know there are other ways I can handle/include this particular situation - I’m just curious if there’s a fast way to view only cells that contain errors in my large database.