Ability to filter column by formula error


#1

Hi!

Right now, if a formula column results in an #ERROR, I am not seeing any way to filter so that just those rows are visible. (Maybe I’m wrong! If so somebody please show me.)

I’d find this useful so I can identify and correct the errors.


#2

You could define an additional Formula field with this formula —

IF(
    ISERROR({FieldToCheckForError}),
    1)

— and then filter for the field being non-zero.