Skip to main content

Formulas pointed at Multiple Select - IF commands, or something else?

  • March 1, 2022
  • 1 reply
  • 28 views
J

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!

This topic has been closed for replies.

1 reply

Dimitris_Goudis
Forum|alt.badge.img+20

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