Discover what data silos are costing your org in our commissioned Forrester study. Learn more

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

Topic Labels: Formulas
170 1
Showing results for 
Search instead for 
Did you mean: 

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!

1 Reply 1

Hey @John_V_Willshire,

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

            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