Count the number of rows where a column (multi select dropdown) has more than one value


I would like to count the number of rows where Attendee Role which is a multi select dropdown has more than one item selected regardless of the item.

Countif({Attendee Role},"*,*") Returns 0

CountM({Attendee Role},"*,*") returns 187 which is the number of rows with 2 selections x 2 counting each selection once (I only have a total of 177 rows so I know this is wrong). I just want to count the rows once.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!