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! Go to 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" ) )
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |