function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Vaishnavi KrishnakumarVaishnavi Krishnakumar 

( VALUE(TEXT(Core_Competencies__c)) + VALUE(TEXT(Experience__c)) + VALUE(TEXT(Leadership_Skills__c)) + IF( Recommend_for_Hire__c , 5, 0) ) / 4

I'm stuck with last unit of the project - create formula and roll-up summary field ...... in which when i copy the formula = ( VALUE(TEXT(Core_Competencies__c)) + VALUE(TEXT(Experience__c)) + VALUE(TEXT(Leadership_Skills__c)) + IF( Recommend_for_Hire__c , 5, 0) ) / 4 .... it is highlighting Recommend_for_Hire__C and mentioning the error - incorrect parameter type for function 'if()'. expected boolean received text.
Best Answer chosen by Vaishnavi Krishnakumar
ravi soniravi soni
hi ,
IF( Recommend_for_Hire__c , 5, 0)
Recommend_for_Hire__c this is text field whereas if condition accept boolean field.
do one thing make it boolean like below this is dummy example for explain. 
IF( Recommend_for_Hire__c = 'text', 5, 0)

if it helps you then don't forget to mark it as best answer.
Thank you

All Answers

ravi soniravi soni
hi ,
IF( Recommend_for_Hire__c , 5, 0)
Recommend_for_Hire__c this is text field whereas if condition accept boolean field.
do one thing make it boolean like below this is dummy example for explain. 
IF( Recommend_for_Hire__c = 'text', 5, 0)

if it helps you then don't forget to mark it as best answer.
Thank you
This was selected as the best answer
AnkaiahAnkaiah (Salesforce Developers) 
Hi Vaishnavi,

Can you please explain, what are you trying to achieve?

Thanks!!