Skip to main content

Hi All,

Wish to create a formula that sums up the values of three picklist fields (A,B,C) all have same possible picklist options i.e "Bad", "Good" and "Very Good" and the corresponding values of these picklists are 0,1,2

 

The Formula that I have tried is not providing the desired results:

TEXT(VALUE(A__c)) + TEXT(VALUE(B__c)) + TEXT(VALUE(C__c))

 

Any help would be highly appreciated in building the correct formula.

#Salesforce Admin

4 respuestas
  1. 30 oct 2023, 12:02 p.m.

    Hello @CHANDRA KANT BAGHEL,

     

    Try this formula:

    VALUE(TEXT(A__c)) + VALUE(TEXT(B__c)) + VALUE(TEXT(C__c))

    This formula converts each picklist field to a text value using the TEXT() function and then converts the text value to a number using the VALUE() function. The numbers are then added together to get the sum.