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
Jyosi jyosiJyosi jyosi 

Validation Rule Problem

Hello Everyone,

I have a picklist field value if the user select any values he need to enter the "Fee_Planning_Start_Date__c" and it work fine
I have other validation where Fee_Planning_Start_Date__c should be always greater that Start_Date__c
Can you please help out to fix this?
AND(
OR(
ISPICKVAL(Fee_Planning_Status__c , 'Pending'),
ISPICKVAL(Fee_Planning_Status__c , 'Terminated'),
ISPICKVAL(Fee_Planning_Status__c , 'Suspended'),
ISPICKVAL(Fee_Planning_Status__c , 'Approved')

),
ISBLANK((Fee_Planning_Start_Date__c)),
)
Best Answer chosen by Jyosi jyosi
SonamSonam (Salesforce Developers) 
try:
AND(
OR(
ISPICKVAL(Fee_Planning_Status__c , 'Pending'),
ISPICKVAL(Fee_Planning_Status__c , 'Terminated'),
ISPICKVAL(Fee_Planning_Status__c , 'Suspended'),
ISPICKVAL(Fee_Planning_Status__c , 'Approved')
),
ISBLANK((Fee_Planning_Start_Date__c)),
(Fee_Planning_Start_Date__c > Start_Date__c)
)

All Answers

SonamSonam (Salesforce Developers) 
try:
AND(
OR(
ISPICKVAL(Fee_Planning_Status__c , 'Pending'),
ISPICKVAL(Fee_Planning_Status__c , 'Terminated'),
ISPICKVAL(Fee_Planning_Status__c , 'Suspended'),
ISPICKVAL(Fee_Planning_Status__c , 'Approved')
),
ISBLANK((Fee_Planning_Start_Date__c)),
(Fee_Planning_Start_Date__c > Start_Date__c)
)
This was selected as the best answer
Deepak BalurDeepak Balur
Try something along these lines please:

OR(
NOT (CloseDate < TODAY()),
(ISBLANK(TEXT(StageName))),
TEXT(StageName) <> "Initial Contact",
TEXT(StageName) <> "Won"
)
Jyosi jyosiJyosi jyosi
Hello Sonam ,
 It;s not triggering .

Thanks,
Jyo
SonamSonam (Salesforce Developers) 
Hey Jyo, Can you please share the exact condition together with an example - its not clear as to how you want the validation to trigger.
Jyosi jyosiJyosi jyosi
Hello Sonam,

I have PickField if the values selected from dropdown the 
Fee_Planning_Start_Date__c should not be blank.

AND(
OR(
ISPICKVAL(Fee_Planning_Status__c , 'Pending'),
ISPICKVAL(Fee_Planning_Status__c , 'Terminated'),
ISPICKVAL(Fee_Planning_Status__c , 'Suspended'),
ISPICKVAL(Fee_Planning_Status__c , 'Approved')

),
ISBLANK((Fee_Planning_Start_Date__c)),
)

I have another StartDate field on rep,
When the Fee_Planning_Start_Date__c is entered it should be greater that StartDate.


This the scenario.

Regards,
Jyo
 
Jyosi jyosiJyosi jyosi
Its has been solved thanks for the inputs