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!