Looking to write a Validation
if I change my opportunity stage to "Stage 3" but if "Field 1(picklist)", "Field 2(Currency)" or "Field 3 (number)" is changed in the same save. that you update these said fields first before you save.
Thanks in advance
1 answer
Hi Rhyan ,
Try this
AND(SrageName, "tage 3"),
OR(
TEXT( Field 1 ) = TEXT(PRIORVALUE(Field 1)),
Field 2 = PRIORVALUE(Field 2),
Field 3 = PRIORVALUE(Field 3),
NOT( ISCHANGED( Field 1 )) ,
NOT( ISCHANGED( Field 2 )) ,
NOT( ISCHANGED( Field 3 ))
)
)
