Skip to main content
Topics#Data ManagementBrittney Valverde の質問
Brittney Valverde (Barracuda Networks) が「#Data Management」で質問
2020年8月12日 1:14

If a picklist contains a value then make a picklist field required

I'm trying to create a validation rule that says that if a picklist value contains the word "strategic", then another picklist value field is required, but I keep getting errors.

 

It says "Error: Field Named_Partner__c is a picklist field. Picklist fields are only supported in certain functions. "

 

Named Partner is the field I want required and is a picklist. Any suggestions?

 

AND(    

 

    CONTAINS(TEXT( Account_Name__r.VRank_Category__c ), 

 

    LOWER('strategic')),

 

     TEXT(ISBLANK( Named_Partner__c ))

 

   )
14 件の回答
  1. Andrew Fragias (Lumary)
    2020年8月12日 2:30
    Hi Brittney,

     

    One thing to note for the CONTAINS function is when using this function in a validation rule or workflow rule, fields that are blank are considered valid. For example, if you have a validation rule that tests to see if the serial number of an asset contains “A,” all assets that have a blank serial number are considered valid.

     

    Can you try the following:

    AND(    
       NOT(ISBLANK(TEXT(Account_Name__r.VRank_Category__c ))), 
        CONTAINS(LOWER(TEXT(Account_Name__r.VRank_Category__c)), 
        'strategic'),
        ISPICKVAL( Named_Partner__c,"" )
       )

     

     
回答を記入...
0/9000