Skip to main content

Hii,

 

I have created the validation rule on personal org and the requirement is given below:

whenever existing opporunity with closed lost stage no one can change stagename and the task is we have to create validation by using IF() function 

 

IF(ISCHANGED(StageName) && PRIORVALUE(StageName)= 'Closed Lost' , true, false)

 

Let me know how to fix this ,

 

Kind Regards

7 answers
  1. Sep 1, 2022, 7:45 AM

    Check the below one

    IF

    (

    AND

    (

    ISCHANGED(StageName),

    TEXT(PRIORVALUE(StageName)) = 'Closed Lost'

    ), TRUE, FALSE

    )

0/9000