4 risposte
Eric Praud (Activ8 Solar Energies) Forum Ambassador
Hi Jyoti,
Create a formula returning a number. I assume the ones without choices are checkboxes:
CASE(CommunicationHealth__c,"Good Communication",2,
"Poor Communication",1, "No Communication",1,0)+
IF(DoWeHaveCorrectPhoneNumber__c,1,0)+
IF(AreTheyDecisionMaker__c,1,0)+
IF(DidWeMakeInitialContact__c,1,0)+
IF(DidTheyHireMitigationCompany__c,1,0)+
IF(QUalifiedProspect__c,1,0)+
IF(WaitingOnInsurance__c,1,0)+
CASE(InterestedInService__c,"Very Interested",2,
"Somewhat Interested",1, "Not Interested",-2,0)
Make sure you use the right API names for fields and picklist values (not labels)