IF(CONTAINS(RecordType.Name,"Closed"),
IF(ISPICKVAL(Name_Address_And_Contact_Details__c,"No"),1,0)+
IF(ISPICKVAL(Is_This_a_Complaint__c,"No"),1,0)+
IF(ISPICKVAL(Complainant_Type__c,"No"),1,0)+
IF(ISPICKVAL(Complaint_About_Whom__c,"No"),1,0)+
IF(ISPICKVAL(Summary_Of_Complaint__c,"No"),1,0)+
IF(ISPICKVAL(Product_Type__c,"No"),1,0)+
IF(ISPICKVAL(Is_It_Claims_Related__c,"No"),1,0)+
IF(ISPICKVAL(Receipt_Date__c,"No"),1,0)+
IF(ISPICKVAL(Complaint_Issue__c,"No"),1,0)+
IF(ISPICKVAL(Resolved_To_Customer_Satisfaction__c,"No"),1,0)+
IF(ISPICKVAL(Decision__c,"No"),1,0)+
IF(ISPICKVAL(Decision_Summary__c,"No"),1,0)+
IF(ISPICKVAL(Cost__c,"No"),1,0)+
IF(ISPICKVAL(Root_Cause_Where__c,"No"),1,0)+
IF(ISPICKVAL(Root_Cause_Why__c,"No"),1,0),0)
답변 7개
Thanks All. Support have come back to me now and it seems the formula result is actually not on the page layout. The one on the page layout is being update by a workflow rule (I didn't build this :) they are going to look into it for me so i'll leave it with them. Thanks for you help though
