- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 22, 2025 03:14 AM
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.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 22, 2025 04:06 AM
Try creating a formula field to extract the numerical value of the select field, and then filter off of that:
VALUE(Select)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 22, 2025 04:06 AM
Try creating a formula field to extract the numerical value of the select field, and then filter off of that:
VALUE(Select)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 22, 2025 04:32 AM
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 22, 2025 05:08 AM - edited ‎Jan 22, 2025 11:32 AM
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.
