Skip to main content

24 de jan. de 2022, 00:21

formula for multiple picklist

Hi there,

Hope anyone could help me.

I have 10 x pick list fields (just Yes or No)

I have another field called Score

what I want to achieve is:

when answer is Yes, get score 1

if answer is No, get score 0

for example, if there are 4 x Yes, then the Score field will show 4

How to make it happen, cheers

David

6 respostas

Sai Praveen Kumar Kakkirala (Salesforce)
24 de jan. de 2022, 04:40
Hi David,
You can write the formula as below with return type as Number.

CASE(TEXT( Picklist1__c ),
"YES",1,
0) +
CASE(Text( Picklist2__c ),
"YES",1,
0)+ CASE(TEXT( Picklist3__c ),
"YES",1,
0)
If this solution helps, Please mark it as best answer.
Thanks,