Good afternoon gurus. I am trying to write formula to sum the number of 'no' values found across multiple picklist fields so I can show a total count.
for example if picklistA = NO , picklistB = NO and PicklistC = No the result would be 3
if for example if picklistA = NO, picklistB = NO and PicklistC = YES the result would be 2
I tried doing this based on an example I found.
VALUE(
CASE(ISPICKVAL(Picklist_Field_1__c, "No"), 1, 1, 0) +
CASE(ISPICKVAL(Picklist_Field_2__c, "No"), 1, 1, 0)
But I get the error Error: Incorrect argument type for function 'CASE()'.
#Salesforce Developer #Formulas #Salesforce Admin
, thank you for your response. I tried it but got a new and improved error.
Error: Incorrect parameter type for function 'VALUE()'. Expected Text, received Number