Skip to main content

I am getting a compile error (too big) for this formula. Any suggestions?

 

IF( AND( Product_Category_Value__r.Name = "Bathroom & Other Sinks", Trade__c<>""),"Complete",

IF( AND( Product_Category_Value__r.Name = "Cabinets",Manufacturer__c <>"", Trade__c <>""),"Complete",

IF( AND( Product_Category_Value__r.Name = "Carpet",Manufacturer__c <>"", Trade__c <>""),"Complete",

IF( AND( Product_Category_Value__r.Name = "Electrical Load Center",Manufacturer__c <>"", Trade__c <>""),"Complete",

IF( AND( Product_Category_Value__r.Name = "Faucets",Manufacturer__c <>"", Trade__c <>""),"Complete",

IF( AND( Product_Category_Value__r.Name = "HVAC",Manufacturer__c <>"", Brand_Usage_Account__c <>"",Trade__c <>""),"Complete",

IF( AND( Product_Category_Value__r.Name = "Kitchen Appliances",Manufacturer__c <>"", Brand_Usage_Account__c <>""),"Complete",

IF( AND( Product_Category_Value__r.Name = "Laundry Appliances",Manufacturer__c <>"", Brand_Usage_Account__c <>""),"Complete",

IF( AND( Product_Category_Value__r.Name = "Tankless Water Heaters",Manufacturer__c <>"", Trade__c <>""),"Complete",

IF( AND( Product_Category_Value__r.Name = "Toilets",Manufacturer__c <>"", Trade__c <>""),"Complete",

IF( AND( Product_Category_Value__r.Name = "Water Heaters",Manufacturer__c <>"", Trade__c <>""),"Complete",

IF( Manufacturer__c<>"","Complete","Not Complete"))))))))))))

5 comments
0/9000