Skip to main content
4 risposte
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    23 set 2022, 08:31

    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)

0/9000