function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Steve HarrisonSteve Harrison 

Help with a formula field?

I need some help creating a formula that will automatically add a value dependent on another field. For example, the new field is called "Region" and I want the following values to appear for each Billing Country value.

If Billing Country = "United States", then Region = "US"
If Billing Country = "France, "Germany", or "United Kingdom", then Region = "Europe"
If Billing Country = any other value or is BLANK, then Region= "ROW"

I have tried using advanced formulars, but just can't nail the right syntax

Thanks for any help in advance.

Steve

Best Answer chosen by Steve Harrison
BalajiRanganathanBalajiRanganathan
IF(BillingCountry='United States', 'US', IF(OR(BillingCountry='France', BillingCountry='Germany', BillingCountry='United Kingdom'), 'Europe', 'ROW' ))

All Answers

BalajiRanganathanBalajiRanganathan
IF(BillingCountry='United States', 'US', IF(OR(BillingCountry='France', BillingCountry='Germany', BillingCountry='United Kingdom'), 'Europe', 'ROW' ))
This was selected as the best answer
Steve HarrisonSteve Harrison
Great!. That did it. Thanks!