I have a text field - multiple choice rating field [Rating Category] with the list of choices as shown in the formula below. I need a second field, numeric, so I can total & average the ratings. I set up this formula in a numeric formula field, but it's not working. What am i doing wrong?
- If(Contains([Rating Category],"0 - Sellers with <1 Year"),1,null,
- If(Contains([Rating Category],"1 - No Performance Issues"),1,null,
- If(Contains([Rating Category],"2 - No Near-term Performance Issues"),2,null,
- If(Contains([Rating Category],"3 - Manager Performance Plan"),3,null,
- If(Contains([Rating Category],"4 - Performance Plan "),4,null)))))