function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Lakshmi SLakshmi S 

Formula issue

Hi Team,

How can we simplify below formula.

OR(AND(OR(ISPICKVAL(Region__c,"West"),ISPICKVAL(Region__c,"North"),ISPICKVAL(Region__c,"South"),ISPICKVAL(Region__c,"East"),ISPICKVAL(Region__c,"Northeast"),ISPICKVAL(Region__c,"Latin America")),Annualized_EBITDA__c >=1500000),AND(OR(ISPICKVAL(Region__c,"A&T AMS"),ISPICKVAL(Region__c,"A&T APAC"),ISPICKVAL(Region__c,"A&T EMEA"),ISPICKVAL(Region__c,"APAC"),ISPICKVAL(Region__c,"Competitors"),ISPICKVAL(Region__c,"DCS"),ISPICKVAL(Region__c,"EMEA"),ISPICKVAL(Region__c,"Govt & PS"),ISPICKVAL(Region__c,"Healthcare"),ISPICKVAL(Region__c,"I&M"),ISPICKVAL(Region__c,"Life Sciences"),ISPICKVAL(Region__c,"LFM")),Annualized_EBITDA__c >=1000000),AND(OR(ISPICKVAL(StageName,"Win (Contract Signed)"),ISPICKVAL(StageName,"Lost Accounts"),ISPICKVAL(StageName,"Lost Pursuits"),ISPICKVAL(StageName,"On Hold"),ISPICKVAL(StageName,"Dead"),ISPICKVAL(StageName,"Declined")),!ISPICKVAL(Win_Loss_Year__c ,"2018"),Annualized_EBITDA__c >=1000000))


Regards
Lakshmi
Alain CabonAlain Cabon
Hi,

You cannot use a regex in a formula but there is also contains.

Contains = Compares two arguments of text and returns TRUE if the first argument contains the second argument. If not, returns FALSE.

CONTAINS("West|North|South|East|Northeast|Latin America", TEXT(Region__c))

is equivalent to:

OR(
ISPICKVAL(Region__c,"West"),
ISPICKVAL(Region__c,"North"),
ISPICKVAL(Region__c,"South"),
ISPICKVAL(Region__c,"East"),
ISPICKVAL(Region__c,"Northeast"),
ISPICKVAL(Region__c,"Latin America")
),

==================================

OR(AND(

OR(
ISPICKVAL(Region__c,"West"),
ISPICKVAL(Region__c,"North"),
ISPICKVAL(Region__c,"South"),
ISPICKVAL(Region__c,"East"),
ISPICKVAL(Region__c,"Northeast"),
ISPICKVAL(Region__c,"Latin America")
),

Annualized_EBITDA__c >=1500000),

AND(

OR(
ISPICKVAL(Region__c,"A&T AMS"),
ISPICKVAL(Region__c,"A&T APAC"),
ISPICKVAL(Region__c,"A&T EMEA"),
ISPICKVAL(Region__c,"APAC"),
ISPICKVAL(Region__c,"Competitors"),
ISPICKVAL(Region__c,"DCS"),
ISPICKVAL(Region__c,"EMEA"),
ISPICKVAL(Region__c,"Govt & PS"),
ISPICKVAL(Region__c,"Healthcare"),
ISPICKVAL(Region__c,"I&M"),
ISPICKVAL(Region__c,"Life Sciences"),
ISPICKVAL(Region__c,"LFM")
),

Annualized_EBITDA__c >=1000000),

AND(

OR(
ISPICKVAL(StageName,"Win (Contract Signed)"),
ISPICKVAL(StageName,"Lost Accounts"),
ISPICKVAL(StageName,"Lost Pursuits"),
ISPICKVAL(StageName,"On Hold"),
ISPICKVAL(StageName,"Dead"),
ISPICKVAL(StageName,"Declined")
),

!ISPICKVAL(Win_Loss_Year__c ,"2018"),

Annualized_EBITDA__c >=1000000))

====================================
Lakshmi SLakshmi S
Hi Alain Cabon,

Thnaks for your suggestion.