Counting number of times a word is used in a select list column when multiple selections are allowed

1

Hi Everyone,

I have a column where multiple select list options can be selected. I want to count the number of times option1 is used in the column. My formula is only counting the number of times option1 is used solo. If there are other options selected with it, it’s not counting those rows. Does anyone know a work-around for this?

My formula is as follows:
MyTable.Filter(Type=Option1).count()

Thanks in advance for any suggestions!
Reiley

2

Instead of saying Type = Option1, try using the Contains() formula. That should work!

[MyTable].Filter([Type].Contains([Option1])).Count()
3

This worked! Thanks so much for your comment. I really appreciate it!

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.