A formula field dependent on a picklist value in Salesforce

Hi Radhakrishna,

This is possible within salesforce platform,

for example:-

I have created some fields which are, 2 picklist(gradeAdded and gradeDeducted), 5 formula fields(score1Add, score2Add, score1Deduct, score2Deduct and gradeTotal) .

picklist value for gradeAdded:-

1.value1

2.value2

picklist value for gradeDeducted:-

1.value1-

2.value2-

formula expressions for given 5 formula fields:-

1.score1Add - IF(TEXT(gradeAdded__c)=='value1' , 20, IF(TEXT(gradeAdded__c)=='value2',10,null))

2.score2Add - IF(TEXT(gradeAdded__c)=='value2' , 20, IF(TEXT(gradeAdded__c)=='value1',10,null))

3.score1Deduct - IF(TEXT(gradeDeducted__c)=='value1-' , 10, IF(TEXT(gradeDeducted__c)=='value2-',5,null))

4.score2Deduct - IF(TEXT(gradeDeducted__c)=='value2-' , 10, IF(TEXT(gradeDeducted__c)=='value1-',5,null))

5.gradeTotal - ( score1Add__c + score2Add__c )-( score1Deduct__c + score2Deduct__c )

If you have any queries please ask.

Hope this helps.

• This reply was modified 7 years, 3 months ago by  shariq.