+ Start a Discussion
streetstreet 

New validation rule

If the Mode1(Picklist field) ivalue is "HELLO" the below mentioned fields should be made mandatory .

 

C1 (Textfield)

Date  (date field)

Navatar_DbSupNavatar_DbSup

Hi,

 

Try the below  validation rule:

IF(ISPICKVAL(Mode1 , "HELLO"), OR( ISBLANK(C1), ISBLANK(Date)),null)

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 

 

 

 

PhanidraPhanidra

It Should be AND in place of OR , like follows

 

IF(ISPICKVAL(Mode1 , "HELLO"), AND( ISBLANK(C1), ISBLANK(Date)),null)

 

or can be done as

 

ISPICKVAL(Mode1 , "HELLO") &&  ISBLANK(C1) && ISBLANK(Date)