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
ShayKhanShayKhan 

Validation rule if Campaign stage = opportunity created do not save record without opportunity link

Hi All!
I needed some assistance creating a simple validation rule, where if Campaign stage = Opportunity Created do not allow record to be saved without an opportunity link.

Thanks!
Best Answer chosen by ShayKhan
Raj VakatiRaj Vakati
This is the corret one 

AND(
ISPICKVAL( Campaign_Stage__c = "Opportunity Created"),
ISBLANK(TEXT(Opportunity__c))
)
 

All Answers

Raj VakatiRaj Vakati
Use the below one. Replace API Names with correct one 


AND(
ISPICKVAL( stage , "Opportunity Created")),
ISBLANK(TEXT(opportunity__link__c )
)
 
ShayKhanShayKhan
Thanks for the prompt response! There's a syntax error in the rule:  Error: Syntax error. Extra ','
Below is the rule with the API names 

AND(
ISPICKVAL( Campaign_Stage__c = "Opportunity Created")),
ISBLANK(TEXT(Opportunity__c)
)
Raj VakatiRaj Vakati
AND(
ISPICKVAL( Campaign_Stage__c = "Opportunity Created"),
ISBLANK(TEXT(Opportunity__c)
)
Raj VakatiRaj Vakati
This is the corret one 

AND(
ISPICKVAL( Campaign_Stage__c = "Opportunity Created"),
ISBLANK(TEXT(Opportunity__c))
)
 
This was selected as the best answer
ShayKhanShayKhan
Awesome, Thanks!