Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Filter not working with select field

Solved
Jump to Solution
398 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Frank472389
4 - Data Explorer
4 - Data Explorer

I have a select drop down  field with number rating from 1 to 10,  1 - 2 - 3 - 4 .. etc...  .   I want to filter all the records that have a rating bigger than, let's say 6, but there's no number operators (">", "<") for the select field.

Is there a solution to this?

thank you in advance.

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try creating a formula field to extract the numerical value of the select field, and then filter off of that:

Screenshot 2025-01-22 at 8.06.17 PM.png

VALUE(Select)

See Solution in Thread

3 Replies 3
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try creating a formula field to extract the numerical value of the select field, and then filter off of that:

Screenshot 2025-01-22 at 8.06.17 PM.png

VALUE(Select)

Thank you!

Frank472389
4 - Data Explorer
4 - Data Explorer

I tried TheTimeSavingC solution and it works perfectly. My select field is called "Rating",  I created a formula field called "Rating Formula" and wrote in the expression box "VALUE(Rating)". The function "VALUE" is needed to convert it to a number.  When I select the drop down from one field, it changes the other accordingly.

Then I added a filter to "Rating Formula" using the math operator ">" and it filters correctly.    Finally, I hid the formula field from view because I don't need to see it.