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.