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.
Best answer by TheTimeSavingCo
Try creating a formula field to extract the numerical value of the select field, and then filter off of that:
VALUE(Select)
+18Try creating a formula field to extract the numerical value of the select field, and then filter off of that:
VALUE(Select)Try creating a formula field to extract the numerical value of the select field, and then filter off of that:
VALUE(Select)Thank you!
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
