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!!