Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List box used for filtering - need to exclude a value

This should be easy..

I have a list box that allows the user to filter on values to be displayed in a separate chart.  The values are

CLOSED

SYSTEM SUPPORT AND MAINTENANCE

PENDING

ESG ACTIVITIES

ACTIVE

I need to exclude ESG ACTIVIES from the list box.

If anyone can point me in the right direction I’d appreciate it.

1 Solution

Accepted Solutions
jvitantonio
Luminary Alumni
Luminary Alumni

Go to the list box properties. In the Field drop down, select <Expression> and write:

=IF (yourField <>'ESG ACTIVITIES', yourField)

View solution in original post

2 Replies
jvitantonio
Luminary Alumni
Luminary Alumni

Go to the list box properties. In the Field drop down, select <Expression> and write:

=IF (yourField <>'ESG ACTIVITIES', yourField)

Not applicable
Author

Thanks!