Forum Discussion

Qrew Cadet

7 years ago

Create a Summary Report from a Multi-select Dropdown Field

Suppose I have a Multi-select field with options (A, B, C) and 100 records where the field is used. Is it possible to create a report that counts each time an option is selected in each record? ...

Qrew Captain

You can do this with three fields.
The formula for [A count] would be

If(Contains(ToText([my multi select field],"A"),1,0)

But be sure that your choices are unique like ABC and not like

Mice
Elaphants
Ants

Because the phrase ants is also in elephants.

Then do similar fields for the [B count] and [C Count]

PaulTrimor

Qrew Cadet

7 years ago

thanks , If(Contains(ToText([my multi select field]),"A"),1,0)