Ask Search:
Melissa FoleyMelissa Foley 

Formula Help: Convert Picklist Values to Numbers


I've got a picklist field "Coaching Capacity" that unfortunately includes numbers and text, options are: "1,2,3, not sure". I know, I tried to avoid this but it's needed.
 
What I need to do is create a formula that will allow me to take the response from "Coaching Capacity" MINUS "Active Clients" (roll-up summary count field) to determine if the coach has any availability. I thought I could do this using VALUE but no luck. Maybe VALUE SUBSTITUTE? Thanks!
 
Best Answer chosen by Melissa Foley
Sunil SarillaSunil Sarilla
Hi Melissa,
Please use the VALUE Function
BLANKVALUE(VALUE(TEXT(Coaching_Capacity__c)),0)
Please use the insert field button to select the field API Name
 

All Answers

Sunil SarillaSunil Sarilla
Hi Melissa,
Please use the VALUE Function
BLANKVALUE(VALUE(TEXT(Coaching_Capacity__c)),0)
Please use the insert field button to select the field API Name
 
This was selected as the best answer
Sarath PSarath P
Hi Melissa, 

Please try the following to convert picklist value to number

VALUE( TEXT( Coaching_Capacity__c ) )
Melissa FoleyMelissa Foley
Sunil, That did the trick with - Active Clients. Thanks for your help!