• Mellola
  • NEWBIE
  • 0 Points
  • Member since 2012

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies

Hi,

I created a validation rule using ISCHANGED with the Status Update field to ensure when someone updates a stage, they also update the Status Update field.  It works in that it gives the person an error when they change a stage, however, it doesn't recognize when the Status Update field has been edited or changed thereby giving an error continually even when the field has been changed. 

 

My code:

AND (
OR (
ISPICKVAL ( StageName, "Initial Review"),
ISPICKVAL (StageName, "Active Review") ,
ISPICKVAL (StageName, "48 In Process"),
ISPICKVAL (StageName, "Proposal Issued"),
ISPICKVAL (StageName, "Underwriting/Due Diligence"),
ISPICKVAL (StageName, "Documentation"),
ISPICKVAL (StageName, "Close-Fund"),

ISCHANGED (Status_Update__c)
))

 

Is there a way to fix this?

Thanks,

ML

Hi,

I created a validation rule using ISCHANGED with the Status Update field to ensure when someone updates a stage, they also update the Status Update field.  It works in that it gives the person an error when they change a stage, however, it doesn't recognize when the Status Update field has been edited or changed thereby giving an error continually even when the field has been changed. 

 

My code:

AND (
OR (
ISPICKVAL ( StageName, "Initial Review"),
ISPICKVAL (StageName, "Active Review") ,
ISPICKVAL (StageName, "48 In Process"),
ISPICKVAL (StageName, "Proposal Issued"),
ISPICKVAL (StageName, "Underwriting/Due Diligence"),
ISPICKVAL (StageName, "Documentation"),
ISPICKVAL (StageName, "Close-Fund"),

ISCHANGED (Status_Update__c)
))

 

Is there a way to fix this?

Thanks,

ML