I'm trying to create a custom field that populates with either "Yes" or "No" based on the state the account is located in.
For example, our Prime States (this term is specific to our company) are AL, FL, IL, KS, MN, MT, NC, ND, NE, NM, OK, OR, PA, TX, UT, and WA.
If an account is located in one of these states, I need the "Prime State" custom data field to populate with "Yes." If an account is not located in this state, I need "Prime State" to populate with "No."
I'm trying to use an "IF" formula, but keep receiving messages that I'm missing parenthesis or that the data field "AL" doesn't exist.
Any guidance would be greatly appreciated!
Thanks,
Nick
@Nick Jablonski Would a CASE function work in this use case?
https://help.salesforce.com/s/articleView?id=sf.customize_functions_case.htm&type=5
Something like,
CASE(BillingState,
"AL", "Yes",
"FL", "Yes",
"IL", "Yes",
...
"No")
