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:
Thanks in advance for any suggestions!