Sign Up ›
  • fabian paul 7
  • NEWBIE
  • 0 Points
  • Member since 2020
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
4 replies

Validation Failed

Hello,

I have an object that has Picklistfield  named  'Status' and I want that whenever the Status Picklist field values is 'Closed Filled' or 'Closed Not Approved' the Close Date field which is of Date type cannot be left blank.

My Logic which is not working is:

IF( ISPICKVAL( Status__c , 'Closed-Filled')  ||  ISPICKVAL( Status__c , 'Closed Not Approved') ,   IF( ISBLANK( Close_Date__c ) ,true, false),false)

Thnaks.

4 replies

Validation Failed

Hello,

I have an object that has Picklistfield  named  'Status' and I want that whenever the Status Picklist field values is 'Closed Filled' or 'Closed Not Approved' the Close Date field which is of Date type cannot be left blank.

My Logic which is not working is:

IF( ISPICKVAL( Status__c , 'Closed-Filled')  ||  ISPICKVAL( Status__c , 'Closed Not Approved') ,   IF( ISBLANK( Close_Date__c ) ,true, false),false)

Thnaks.