Count Enumlist Instances in current Form

[YGY]

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.

[Marc_Dillon]

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 )

[YGY]

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

[Marc_Dillon · 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" ) )

[YGY]

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

[Marc_Dillon]

YGY:

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

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

[YGY]

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

[Marc_Dillon]

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

[YGY]

Thanks… makes sense

[Steve]