When it comes to picklist in formula fields, there are few things which developer need to consider.
- Do you want picklist actual value (return text value)?
- Do you want to check if user has selected a specific value (return true or false.)?
There are 3 functions that can be used for different purpose to work with picklists in formula field.
- ISPICKVAL()
- CASE()
- TEXT()
