Skip to main content
Topics#Data ManagementPregunta de Samson Torregiante
Samson Torregiante (Catalina Marketing USA) preguntó en #Data Management
25 ene 2021, 21:17

Need help with a validation rule

I have a custom field (picklist) named 'Email Resolution Sent' with a None\Yes\No value.  I have a validation Rule (below) to check for two additional pick list fields 'Status' and 'Type'.  The validation rule is working fine but when a user attempts to fill in the data values (selections of None, Yes, or No) nothing selected in the picklist drop down value takes and the validation rule error I wrote just keeps displaying.

 

AND(

 

ISPICKVAL( Status , 'Closed'),

 

ISPICKVAL (Type , 'Incident')

 

)

 

 
5 respuestas
  1. Samson Torregiante (Catalina Marketing USA)
    26 ene 2021, 14:07
    Got it, I had to compose an IF statement and also to convert to text with the below formula:

     

    IF(

     

    AND(

     

    TEXT(Type) = "Incident",

     

    TEXT (Status) = "Closed",

     

    ISBLANK(TEXT(Email_Resolution_Sent__c))), True, False )
Escribir una respuesta...
0/9000