Skip to main content
Topics#Data ManagementRoger Bannister の質問
Roger Bannister が「#Data Management」で質問
2015年5月27日 22:22

What is wrong with this validation formula?

AND(ISPICKVAL(StageName,"Stage 6 - Closed Lost"), 

 

(ISPICKVAL(Reason_Opportunity_Lost__c, "--None--" )))

 

If the Opportunity is being edited and they change "Stage" to Stage 6 - Closed Lost but do not update "Reason Opportunity Lost" field from --None-- they get an error message.

 

Thanks, Roger
8 件の回答
  1. Mayank Srivastava (eVerge Group)
    2015年5月27日 22:28
    AND (
       ISCHANGED(StageName),
       TEXT(StageName) = "Stage 6 - Closed Lost",
       ISBLANK(TEXT(Reason_Opportunity_Lost__c))
    )
回答を記入...
0/9000