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
rahul khan 6rahul khan 6 

Guys I have written a validation rule on opportunities even if whatsapp number(formula field)isn't empty it showing empty i'll post my validation rule

I'm copying whatsapp no. from contacts plzz help me out


OR(IF( 
AND( 
TEXT( StageName ) = "Need Analysis", 
ISBLANK( Whatsapp_Number__c )), True, False 
), 
IF( 
AND( 
TEXT( StageName ) = "Proposal", 
ISBLANK( Whatsapp_Number__c )), True, False 
), 
IF( 
AND( 
TEXT( StageName ) = "Negotiation", 
ISBLANK( Whatsapp_Number__c )), True, False 
), 
IF( 
AND( 
TEXT( StageName ) = "Registered", 
ISBLANK( Whatsapp_Number__c )), True, False 
), 
IF( 
AND( 
TEXT( StageName ) = "Demo Confirmed", 
ISBLANK( Whatsapp_Number__c )), True, False 
), 
IF( 
AND( 
TEXT( StageName ) = "Demo Completed", 
ISBLANK( Whatsapp_Number__c )), True, False 
) 


)
Murali MattaMurali Matta
Hi Rahul,

Create a Formula field or use Workflow Rule  Field Update to copy the number from Contact to Opportunity.

Validation rule: It verify that the data a user enters in a record meets the standards you specify before the user can save the record.

For Picklist value please use the "ISPICKVAL" and use the full stage name.
Example: 
If you are having '5 - Negotiation & Closure' use '5 - Negotiation & Closure'.
Don't use  '5 - Negotiation & Closure' as 'Negotiation & Closure'.

Please check the below code.

IF( 
AND( 
ISPICKVAL( StageName ) = "Need Analysis", 
!ISBLANK( Whatsapp_Number__c )), Whatsapp_Number__c , IF( 
AND( 
ISPICKVAL( StageName ) = "Proposal", 
!ISBLANK( Whatsapp_Number__c )), Whatsapp_Number__c , IF( 
AND( 
ISPICKVAL( StageName ) = "Negotiation", 
!ISBLANK( Whatsapp_Number__c )), Whatsapp_Number__c , IF( 
AND( 
ISPICKVAL( StageName ) = "Registered", 
!ISBLANK( Whatsapp_Number__c )), Whatsapp_Number__c , IF( 
AND( 
ISPICKVAL( StageName ) = "Demo Confirmed", 
!ISBLANK( Whatsapp_Number__c )), Whatsapp_Number__c , IF( 
AND( 
ISPICKVAL( StageName ) = "Demo Completed", 
!ISBLANK( Whatsapp_Number__c )), Whatsapp_Number__c ,' '
) ) ) ) ) )

Thanks,
Murali