Hi All,
I am getting Error as #error in few records in formula field .
below is formula field. please sugget me.
IF(ISPICKVAL(Status__c,'Active'), 
(IF((TODAY()>=DATE(YEAR(Renewal_Date__c)- (IB_Products_Country_Attributes__r.Phase_1_End_Date_Months__c/12) ,MONTH(Renewal_Date__c),DAY(Renewal_Date__c)) && (TODAY()<=Renewal_Date__c)),'Renewal', 
IF(TODAY()<=DATE(YEAR(Install_Date__c) + (IB_Products_Country_Attributes__r.Phase_3_Start_Date_Months__c/12),MONTH(Install_Date__c),DAY(Install_Date__c)),'Initial',
IF((Today()> Renewal_Date__c) || (ISBLANK(Renewal_Date__c)),'Renewal Overdue',
'Operational')))),'')


Thanks,
Chetan

Hi All,
I am getting Error as #error in few records in formula field .
below is formula field. please sugget me.
IF(ISPICKVAL(Status__c,'Active'), 
(IF((TODAY()>=DATE(YEAR(Renewal_Date__c)- (IB_Products_Country_Attributes__r.Phase_1_End_Date_Months__c/12) ,MONTH(Renewal_Date__c),DAY(Renewal_Date__c)) && (TODAY()<=Renewal_Date__c)),'Renewal', 
IF(TODAY()<=DATE(YEAR(Install_Date__c) + (IB_Products_Country_Attributes__r.Phase_3_Start_Date_Months__c/12),MONTH(Install_Date__c),DAY(Install_Date__c)),'Initial',
IF((Today()> Renewal_Date__c) || (ISBLANK(Renewal_Date__c)),'Renewal Overdue',
'Operational')))),'')


Thanks,
Chetan