Skip to main content

Hi!  

I need assistance with a formula.  I am trying to create one where IF date field contains 2015 AND status is PICKVAL "Actual", THEN show amount field.  

 

This is what I have and I'm getting an error.

 

(IF(CONTAINS( Booking_Date__c , "2015"))

and

IF(ISPICKVAL(Status__c , "Actual") ),  Booking_Amount__c , 0)

 

The below worked for displaying the amount based on Status.

 

IF(ISPICKVAL(Status__c , "Actual") , Booking_Amount__c , 0)

 

Thank you in advance for your help!!

2 comentários