I think the title says it all, we are using picklist values having different Label and API Name. How can I display the Picklist label instead of API in when using a formula field. I know I can use IF statements and ISPICKVAL but is there a more dynamic solution, so that when new picklist values are added no need to edit the formula again.
Sample Picklist Values
Small Business – SAP_A
Medium Business – SAP_B
Unfortunately this feature does not seem to exist yet. Vote for this Idea: