Hi All,
I need help creating a validation rule, where if the Type = New Logo
and the Opportunity stage = Closed Won Pending.
Here are six fields -
Platform__c
Ease_Of_Use_W__c
Customer_Service_W__c
Price_W__c
Solution__c
Any of them should be filled with a value, it should not be blank. If blank it should give error that any of the fields should be updated with the value.
@Who owes me a beer?!?@* Sales Cloud - Getting Started *@* Sales Cloud - Best Practices *@Admin Group, lucknow, IN@Trailblazer Community Cove
Try something like this
AND(
TEXT( Type ) = 'New Logo',
ISCHANGED( StageName ),
CASE(StageName,
'Closed Won Pending',1,
'Closed Won',1,
0 ) = 1
OR(
ISBLANK(Platform__c) ,
ISBLANK(Ease_Of_Use_W__c),
ISBLANK(Customer_Service_W__c),
ISBLANK(Price_W__c),
ISBLANK(Solution__c)
)
)
