I'm creating a filter function now. For text,...

security
(Chin Wai Liu) #1

I’m creating a filter function now. For text, I’m using ‘in’ function for Security filter. And it works.

But for a range of number, says 200-300, I think using ‘in’ is not the best option. Does anyone know which function I should use?

P.S I’ve used INT for the format of the column already.

Thanks!

(Praveen Seshadri (AppSheet)) #2

AND([NumberColumn] > 200, [NumberColumn] < 300)

Is that what you’re looking for?