Skip to main content

Hi there. I have a multiple select column that contains seven audience types, which have been added in a different order (no set pattern).

I also know how big these audiences are (eg Generalists = 4406).

I’m trying to write a formula that returns a total audience based on whatever has been selected in that multiple select box.

EG if “Generalists” and “Digital” have been selected, in any order, it counts 4406 + 106

I can write an IF command to create a value for an exact match in the box (e.g. ONLY says “Generalists”), but stuck on how writing this more complete form.

Any help gratefully received!

Hey @John_V_Willshire,

You have to use a combination of nested formulas in the following structure:

IF( 
   AND(
            REGEX_MATCH({multiple_select},"value 1")=1,
            REGEX_MATCH({multiple_select},"value 2"=1),
            ) ,
    "The multiple select hase both value 1 and value 2 selected" , 
    "Add here the nested IF in the same logic"
   )

Please tell me if it works for you and if you need any further support feel free to text us back.

Yours sincerely,
Dimitris Goudis

Terms & ConditionsAccessibility statement