Formula Request: IndexOf()

[MultiTech]

The current method is... convoluted (to say the least)

--------------------------------------------------------------------------------------------------------------------
Cheers; and as always, thanks for considering!

[dbaum]

Do you mean something different than  New expression: INDEXOF() - Google Cloud Community ?

[Koichi_Tsuji]

I understand what @MultiTech  means (probably) here in this context.

The current AppSheet heavy expression such as -

COUNT(
SPLIT(
ANY(
SPLIT(
(" , " & [EnumList] & " , "),
(" , " & [Enum] & " , ")
)
),
" , "
)
)

Which is equivalent with INDEXOF(), but really tedious.

Better to have straightforward genuine INDEXOF() expression with AppSheet. Voted.

[MultiTech]

@Koichi_Tsuji yep, that's the idea; only I've used the following:

count(
 split(
   left(
 concatenate(ENTER_LIST_HERE),
 find(
   "WHAT_TO_FIND",
concatenate(ENTER_LIST_HERE)
 ) + (LEN(Concatenate("WHAT_TO_FIND")) - 1)
),
 " , ")
)

 Would be much cleaner if I could just get the number:

• IndexOf({List_To_Search}, "Item_To_Find")