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
JakeRattner2's avatar
JakeRattner2
Qrew Trainee
7 years ago
I'd suggest using a numeric formula field if possible because I think you're looking for a number as the output of your formula.  If you wanted to keep using a text formula field you might be able to use this formula based on what you provided:

If([Tubs Needed]="NONE","0",ToText(Length([Tubs Needed])))

Though for reporting purposes a numeric field seems like the way to go