count retuning 1 with two items in a list

Hi guys 

thanks for help, please refer to the clip below, SELECT formula works good in identifying two objects, but count returning 1, why? 

 

sathishk_0-1706114669095.png

 

Solved Solved
1 2 49
2 ACCEPTED SOLUTIONS

Hey man, 

try this instead and see where it leads you to:
LEN(SPLIT([YourList], ","))

View solution in original post

thanks a lot for the solution

LEN usage returned error

But this worked COUNT(SPLIT([YourList], ","))>1

View solution in original post

2 REPLIES 2

Hey man, 

try this instead and see where it leads you to:
LEN(SPLIT([YourList], ","))

thanks a lot for the solution

LEN usage returned error

But this worked COUNT(SPLIT([YourList], ","))>1

Top Labels in this Space