validity of list of values for the given range

AppSheet AppSheet Q&A
,
1

Hi,

I want to check if any of the value from the list lies between the given range. Is there any expression in Appsheet to achieve this?

2

Could you share some examples of the desired requirement -both range and the list?

2 Likes
3

for ex i want to check if any one number from List {1,5,10} lies between 9 and 21. Since 10 lies in-between so result should be “TRUE”.

1 Like
4

Thank you. The following expression is a bit convoluted but should work

In the expression below, [Range_Start] is the starting of the range which is 9 in your example.

[Range_End] is the ending of the range which is 21 in your example.

[Test_List] is the list {1, 5, 10} or for that matter any number list.

OR(IN([Range_Start], [Test_List]),
IN([Range_End], [Test_List]),

COUNT(
SPLIT(
ANY(
SPLIT(
(" , " & SORT([Test_List]+LIST( [Range_Start], [Range_End]), FALSE) & " , “),
(” , " & [Range-End] & " , ")
)
),
" , "
)
)

COUNT(
SPLIT(
ANY(
SPLIT(
(" , " & SORT([Test_List]+LIST( [Range_Start], [Range_End]), FALSE) & " , “),
(” , " & [Range_Start] & " , ")
)
),
" , "
)
) >1

)

2 Likes