Skip to main content

Ability to filter column by formula error

  • March 1, 2018
  • 1 reply
  • 11 views
D
Forum|alt.badge.img+9

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.

    L

    1 reply

    W
    Forum|alt.badge.img+5
    • W_Vann_Hall
    • Inspiring
    • March 1, 2018

    You could define an additional Formula field with this formula —

    IF(
    ISERROR({FieldToCheckForError}),
    1)

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

    D
    Terms & ConditionsAccessibility statement