I'm new to coding in Salesforce and I'm trying to code the following logic:

If a certain picklist value is chosen, another certain field cannot be left blank.

I wrote the following but I'm not sure what's wrong:

IF((ISPICKVAL(Stage,"Lost")), ISBLANK( Reason_Lost)).

Can someone please explain to me what I'm doing wrong?


Can you please try the formula AND( ISPICKVAL(Stage, 'Lost') , ISBLANK( TEXT(Reason_Lost__c)))

EDIT:updated my answer as you told Reason_Lost field is Picklist


IF(AND((ISPICKVAL(Stage,"Lost")), ISBLANK( Reason_Lost)),TRUE, FALSE)

  • I get the error that the field 'Reason_lost' is a picklist field. Is there a function I can use to check if it's empty or not that is the equivalent of 'ISBLANK'? – Dezzie Apr 7 '14 at 15:08
  • IF(AND((ISPICKVAL(Stage,"Lost")), ) ISPICKVAL(Credit_Card__c," "), TRUE, FALSE) – Kiran Mutturu Apr 7 '14 at 15:13

AND((ISPICKVAL( StageName ,"Closed Lost")), ISBLANK(TEXT( Reason_Lost__c )))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for?Browse other questions tagged or ask your own question.