Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Filter not working with select field

Solved
Jump to Solution
377 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.