What I need: How do I get the formula field to work? I’ve been trying to get something much more complicated then this to work but not a single thing I do manages to get the formula field to work. I take two Text fields give them data labels of Comoneten and Comtwoten, give them a value of 10 and then build a Formula field that is sCamoneten] + Camtwoten] and the fx does nothing. Swap to numbers fields, nothing, remake the Formula field just in case, nothing. What am I not understanding about Formula fields?
What I really want: I have a series of questions on a document that I want to add up the numerical value of each response. I have 6 questions all that can be answered with Yes, Sometimes or No which correspond to 10, 5 or 0 and once all 6 questions are done I’d like to get them summed up.
Currently I have Radio Buttons for the responses and then each of those and a Read Only field with 10 5 and 0 Hidden and only set to show up if the right button is selected, then I have a Formula that does this, tCom1-0] + 1Com1-10] + -Com1-5] + 1Com2-0] + 2Com2-10] + -Com2-5] + 2Com3-0] + 3Com3-10] + -Com3-5] + 3Com4-0] + 4Com4-10] + -Com4-5] + 4Com5-0] + 5Com5-10] + -Com5-5] + 5Com6-0] + 6Com6-10] + -Com6-5] but I get nothing to pop up in the field.