Below are the values in the picklist and I need to report just the numerical portion of the value in another custom field that will be used for doing averages. I'm having issues getting it to work. Any help/advice you have would be great! Thank you in advance!
1 - (Very Dissatisfied)
2 - (Dissatisfied)
3 - (Fairly Dissatisfied)
4 - (A Few Minor Issues)
5 - (Neutral)
6 - (Just 'ok')
7 - (Fairly Satisfied)
8 - (Satisfied)
9 - (Very Satisfied)
10 - (Extremely Satisfied)
2 answers
Hi Abby,
Use this formula
CASE(Picklist,
"1 - (Very Dissatisfied) ", 1,
"2 - (Dissatisfied)", 2,
"3 - (Fairly Dissatisfied)",3,
"4 - (A Few Minor Issues)", 4,
"5 - (Neutral)",5,
"6 - (Just 'ok')", 6,
"7 - (Fairly Satisfied)", 7,
"8 - (Satisfied)", 8,
"9 - (Very Satisfied)", 9,
"10 - (Extremely Satisfied)", 10,
0)
