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
BlancaAnderson's avatar
BlancaAnderson
Qrew Assistant Captain
7 years ago
That is correct, I want to count each letter as +1 only.  If NONE is selected then it should say 0

I tried this:
If([Tubs Needed]="NONE",0,Length([Tubs Needed]))

and received this error on the = sign

The operator '=' can't be applied to on types textlists text

I am using a Formula Text field.  


  • JustinTorrence's avatar
    JustinTorrence
    Qrew Cadet
    7 years ago
    Instead of [Tubs Needed]="NONE", try this:
    Contains([Tubs Needed], "NONE")