0

I was struck at a point where I want to populate a formula field in an object based on the billing state. I've tried below formula and it worked.

CASE( BillingState,
'AP', 'IST',
'TL', 'IST',
'ALASKA', 'EST',''
)

The field is taking only upper case letters. I want my field to accept values both in upper and lower case. Can someone help me on what needs to be added to my code snippet.

Thanks in Advance...

1 Answer 1

5

I think using the UPPER() formula would do the job: https://help.salesforce.com/articleView?id=customize_functions_i_z.htm&type=5

CASE( UPPER(BillingState),
'AP', 'IST',
'TL', 'IST',
'ALASKA', 'EST',''
)
1
  • Thanks for your quick response and it worked.
    – user85512
    Commented Jan 19, 2021 at 12:47

You must log in to answer this question.