Skip to main content
Topics#Data ManagementJonathan White의 질문
Jonathan White (Salesforce) 님이 #Data Management에 질문했습니다
2016년 8월 10일 오후 4:31

Validation rule on probability and forecast picklist

Hello We would like to have a validation rule that ensures a user fills in a forecast drop down if the probality is greater than 50% to either includes or Excludes (these are the only values along with None in the Picklist)

 

The Field Names are as follows:

 

Probability (>=50%)

 

Forecast__c (Includes, excludes (picklist))

 

My Formula looks like this but does not work

 

AND( 

 

Probability >= 50, 

 

ISPICKVAL(Forecast__c, "") 

 

)

 

Can somebody help me please
답변 1개
  1. Sunil Sarilla (M&G Investments)
    2016년 8월 10일 오후 4:33
    Hi Jonathan,

     

    Please try the below

    AND( 
    Probability >=0.5, 
    ISBLANK(TEXT(Forecast__c))
    )

     

     
답변을 작성하세요...
0/9000