Count Enumlist Instances in current Form

YGY
Silver 1
Silver 1

Hello,

Have a form with and EnumList with {1-A1, 2-A2, 3-A4, 1-L1, 2-L2, 3-L3}

I would like to count how many times anything with “-A” is selected in a virtual column. It should count the options the users selected in the open form, so not in the spreadsheet yet.

Any help would be appreciated.

Thanks.

Solved Solved
0 9 672
1 ACCEPTED SOLUTION

Maybe try this. Convert the list to Text first, then split the Text back into a List, but on the characters “-A”, then count the List.

COUNT( SPLIT( TEXT( [enumlist] ) , "-A" ) )

View solution in original post

9 REPLIES 9
Top Labels in this Space