+ Start a Discussion
sanjusfdcsanjusfdc 

Validation rule based on another field value change.

Hi All,
If Rating(Piclist field) is "Warm" then only  FieldA,FieldB and FieldC should be editable for other picklist value should not ediatble.

Thanks in advance.
 
SHAHNA MULLASHAHNA MULLA

Hi,

Try below logic.
IF(TEXT( PRIORVALUE(Rating) ) != 'Warm', IF(FieldA = PRIORVALUE(FieldA) && FieldB = PRIORVALUE(FieldB) && FieldC = PRIORVALUE(FieldC), false,true) ,false)

Let me know, whether it helped or not.
Thanks........