Forum Discussion

BlancaAnderson's avatar
BlancaAnderson
Qrew Assistant Captain
7 years ago

Counting Varies Depending on Multiple Choice Selected

I have a multiple choice field that displays the following: -NONE -A -B -C -D I need a new formula field that displays "0" if NONE is selected and then if any other letters are selected to a...
App builders
Formulas and functions
JustinTorrence's avatar
JustinTorrence
Qrew Cadet
7 years ago
Because you are using a text list, you have to do some mapping.
Try this:

var number a = if(contains([Tubs Needed], "A"),1,0);
var number b = if(contains([Tubs Needed], "B"),1,0);
var number c = if(contains([Tubs Needed], "C"),1,0);
var number d = if(contains([Tubs Needed], "D"),1,0);
If(
    contains([Tubs Needed], "NONE"),0,
    $a + $b + $c + $d
)