I have the following validation logic: IF(AND(TEXT(StageName) = 'Agreement', NOT(PRIORVALUE(StageName) = 'Qualification')), true, false), the Idea is if your current stage is Agreement and you prior stage is from anything other than Qualification, it should throw an error. But it throws the error even if my current stage is Agreement and my prior stage is Qualification.


Please check if this works:

ISPICKVAL( StageName , "Agreement"),
NOT( ISPICKVAL( PRIORVALUE( StageName ) ,"Qualification"))
  • An explanation would make this a much better answer. How is this different from what OP already has? Why does that difference matter? Why do you think this should work? You should edit your answer to add that. – Derek F Jun 25 '20 at 11:20

AND(TEXT(StageName) == 'Agreement', PRIORVALUE( TEXT(StageName)) != 'Qualification')

  • 4
    Welcome to the site! Can you ad some explanation as to what was wrong and why this solves it? – Matt Lacey Aug 14 '20 at 1:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.