You can use field validation so that the number value appears or the text is used to "become the equivalent number".
You already have the values!
Case ( Lower(self) = "no" ; 0
; Lower(self) = "maybe" ; 1
; Lower(self) = "yes"; 2
; Int(self) = self; self // keep as number
... more validation as needed ...
; "" // default is empty, if desired
It is used for field auto-enter calculation, not validation.
You can just add a calculation field:
Case ( MngrEval = "yes" ; 2 ; MngerEval = "maybe" ; 1 ; 0) #assuming you don't have any empty fields
Then just use the calculation field to do your maths; hmm, what happens if they both say maybe.....
You are correct 19752. Auto-enter, not Validation under the Field Options.
Thank you Beverly,
I ended up creating new intermediate calculation fields that were strict one digit case fields so if field A(mgmt response) was yes, field B = 2, etc. I then just used the simple calculation that I had set up before using the calculation fields instead of the mgmt response fields.