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
MitChandolaMitChandola 

Any idea why it is not working? VR for stages

I used the below VR for the stages mentioned and need all fields to be filled if these stages are picked. However, the VR is not working. Any idea?

AND( 
CASE( 
"StageName", 
"S1 - Qualification", 1, 
"S2 - Solution Development", 1, 
"S3 - Proposal", 1, 
"S4 - Finalist", 1, 
"S5 - Verbal Award", 1, 
"Closed Won", 1, 
"Closed Lost", 1, 
0 
) = 1, 
OR( 
ISNULL( Implementation_Estimate__c ), 
ISBLANK(TEXT( Implementation_Fee_Included_in_Total_ACV__c )), 
ISNULL( Revenue_Recognition_Date__c ), 
ISBLANK(TEXT( Compelling_Event__c )) 
) 
)
Raj VakatiRaj Vakati
Try this
  
AND( 
IF(
CASE( 
StageName, 
"S1 - Qualification", 1, 
"S2 - Solution Development", 1, 
"S3 - Proposal", 1, 
"S4 - Finalist", 1, 
"S5 - Verbal Award", 1, 
"Closed Won", 1, 
"Closed Lost", 1, 
0 
) ==1)
, 
OR( 
ISNULL( Implementation_Estimate__c ), 
ISBLANK(TEXT( Implementation_Fee_Included_in_Total_ACV__c )), 
ISNULL( Revenue_Recognition_Date__c ), 
ISBLANK(TEXT( Compelling_Event__c )) 
) 
)