I am already doing this part, Create Additional Formulas where I am supposed to paste the formula, ( VALUE(TEXT(Core_Competencies__c)) + VALUE(TEXT(Experience__c)) + VALUE(TEXT(Leadership_Skills__c)) + IF( Recommend_for_Hire__c , 5, 0) ) / 4
However, when I run syntax, i get this error message -- Error: Incorrect parameter type for function 'TEXT()'. Expected Number, Date, DateTime, Picklist, received Text #Trailhead
Thanks!
2 answers
Please make sure all the below fields are picklist fields. Core_Competencies__c
Experience__c
Leadership_Skills__c
From the error message it seems at least one of the field is not picklist hence the error.
