I'm trying to: Give a 1 if the Cancellation date is in 2014 and the Cancellation Type is "30 day cancel", else give a 0.
Here is my formula:
IF(
(AND
(YEAR( Cancellation_Date__c ) = 2014),
ISPICKVAL(Reason_For_Cancellation_Type__c, "30 Day Cancellation")),
1,0)
What am I missing?
3 answers
You could write something like this: IF(
AND(
YEAR(Cancellation_Date__c) = 2014,
ISPICKVAL(
Reason_For_Cancellation_Type__c,
"30 Day Cancellation"
)
),
1,
0
)
