Filter to show only cells that have an error?

#1

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.
image

**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.

#2

Kinda sketchy but try filtering with

=IsText(thisRow.yourColumn)

This should work if the non-error state is an object (e.g. a column lookup to another users table, or the first name of a User object, etc.). Probably would not work if it’s just a simple text select where you’ve set a validation list though.

But yeah, there should be an isError() style check. I don’t see anything like that in the docs.

1 Like