i have a picklist field on a custom object status=closed,open,reopen .imagine that status=closed. write a validation rule to open the case when we select reopen only,if i select open must throw an error message ?

Question

i have a picklist field on a custom object status=closed,open,reopen .imagine that status=closed. write a validation rule to open the case when we select reopen only,if i select open must throw an error message  ?

Chidambar Reddy · Accepted Answer

Hi Hanumanth,   Use this fomula in validation    AND(ISPICKVAL(PRIORVALUE( Status__c ), "Closed") ,ISPICKVAL( Status__c , "Open"))

i have a picklist field on a custom object status=closed,open,reopen .imagine that status=closed. write a validation rule to open the case when we select reopen only,if i select open must throw an error message ?

Collaboration

関連学習

さらにヘルプを表示