Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Re: Help me create a filter for a range of numbers

66 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello all,

I have a range of random numbers. For example: 7, 13, 24, 28, 32, 35, 37, 40, 42.
I need a filter that filter numbers into separate section. For example, “1st section” includes 1, 3, 5, 7, 9 then the “7” above will be filtered into that “1st section” and so on.

Is there anyway to do this with formula? Like if the value is “7”, it will have the “1st section” text or something similar

2 Replies 2

Hi @Dean_Tan,

I dont get your question. Please be more clear so we can help you. A screenshot would be great.

BR,
Mo

If you are talking about a field number, you could:

  • Create Views and add the desired Filters, for example, Number is smaller than 10.
  • If you want to separate by tens, you could add an extra Formula field dividing by 10, and then Gouping by it, so you’d get groups of tens. Of course could create Views too.