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
It was unclear, but I think you are counting the number of characters in the multiple choice. Am I correct?
If so, this numeric formula might do it:
If(
     [Letters Field] = "NONE", 0,
     Length([Letters Field])
)