This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Ability to filter column by formula error

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
David_Smedberg
6 - Interface Innovator
6 - Interface Innovator
‎Mar 01, 2018 10:37 AM

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.

Comment
1 Comment
W_Vann_Hall
13 - Mars
13 - Mars
‎Mar 01, 2018 10:56 AM
‎Mar 01, 2018 10:56 AM

You could define an additional Formula field with this formula —

IF(
    ISERROR({FieldToCheckForError}),
    1)

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

Copyright © 2024 Khoros, LLC