Count Enumlist Instances in current Form

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.

Are the values you listed the only possible options there will ever be?

You could perhaps just do a simple brute-force expression:

0
+
IF( IN( "1-A1" , [enumlist] ) , 1 , 0 )
+
IF( IN( "2-A2" , [enumlist] ) , 1 , 0 )
+
IF( IN( "3-A4" , [enumlist] ) , 1 , 0 )

Thanks, but no - EnumList is dynamic, that’s why I’m trying to count if list item has “-A”.

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" ) )
1 Like

Very close

It works, but starts off with 1 even if the EnumList is clear; choosing 4 options with “-A4” gives a count of 5.

I can add a -1 to the end of the expression, but would rather not… any ideas?

Thank you again

Yes, do that. Why do you not want to?

1 Like

Because I want to know/learn why there’s a 1 :slight_smile:

If you cut something 0 times, how many pieces do you have?
If you cut something 4 times, how many pieces do you have?

2 Likes

Thanks… makes sense

2 Likes

:+1:

1 Like