You need to sign in to do that
Don't have an account?
RichardR1
Error: Incorrect parameter type for function 'OR()'
Sorry in advance, the string below is long. I don't know why I got the error message "Error: Incorrect parameter type for function 'OR()'. Expected Boolean, received Text"
OR(
IF(
AND(
OR(
PE_company__c = FALSE ,
PE_Portfolio_Company__c = FALSE
) ,
OR(
CONTAINS(LinkedIn_Company_Size__c ,'Self-employed') ,
CONTAINS(LinkedIn_Company_Size__c ,'2-10 employees') ,
CONTAINS(LinkedIn_Company_Size__c ,'N/A') ,
CONTAINS(LinkedIn_Company_Size__c ,'')
)
) ,
'0.5' , '0'
) ,
IF(
OR(
AND(
Years_of_work_exp__c >= 8 ,
NOT(
OR(
CONTAINS(LinkedIn_Company_Size__c ,'Self-employed') ,
CONTAINS(LinkedIn_Company_Size__c ,'2-10 employees') ,
CONTAINS(LinkedIn_Company_Size__c ,'11-50 employees') ,
CONTAINS(LinkedIn_Company_Size__c ,'N/A') ,
CONTAINS(LinkedIn_Company_Size__c ,'')
)
)
) ,
OR(
CONTAINS( Current_Title__c , 'director') ,
CONTAINS( Current_Title__c , 'vice president') ,
CONTAINS( Current_Title__c , 'president') ,
CONTAINS( Current_Title__c , 'general manager') ,
CONTAINS( Current_Title__c , 'chief') ,
CONTAINS( Current_Title__c , 'officer') ,
CONTAINS( Current_Title__c , 'CEO') ,
CONTAINS( Current_Title__c , 'COO') ,
CONTAINS( Current_Title__c , 'CSO') ,
CONTAINS( Current_Title__c , 'CTO') ,
CONTAINS( Current_Title__c , 'CFO') ,
CONTAINS( Current_Title__c , 'CHRO') ,
CONTAINS( Current_Title__c , 'SVP') ,
CONTAINS( Current_Title__c , 'EVP')
)
) ,
'1', '0'
) ,
IF(
AND(
OR(
PE_company__c = TRUE ,
PE_Portfolio_Company__c = TRUE
) ,
OR(
Years_of_work_exp__c >= 8 ,
CONTAINS( Current_Title__c , 'managing director') ,
CONTAINS( Current_Title__c , 'principal') ,
CONTAINS( Current_Title__c , 'vice president') ,
CONTAINS( Current_Title__c , 'president') ,
CONTAINS( Current_Title__c , 'vp') ,
CONTAINS( Current_Title__c , 'operating') ,
CONTAINS( Current_Title__c , 'partner') ,
CONTAINS( Current_Title__c , 'executive') ,
CONTAINS( Current_Title__c , 'chief') ,
CONTAINS( Current_Title__c , 'general manager') ,
CONTAINS( Current_Title__c , 'officer') ,
CONTAINS( Current_Title__c , 'CEO') ,
CONTAINS( Current_Title__c , 'COO') ,
CONTAINS( Current_Title__c , 'CSO') ,
CONTAINS( Current_Title__c , 'CTO') ,
CONTAINS( Current_Title__c , 'CFO') ,
CONTAINS( Current_Title__c , 'CHRO') ,
CONTAINS( Current_Title__c , 'Director') ,
CONTAINS( Current_Title__c , 'Portfolio operations') ,
CONTAINS( Current_Title__c , 'Talent') ,
CONTAINS( Current_Title__c , 'Chief talent officer') ,
CONTAINS( Current_Title__c , 'Head of HR') ,
CONTAINS( Current_Title__c , 'SVP') ,
CONTAINS( Current_Title__c , 'EVP')
)
) ,
'2', '0'
)
)
Thanks,
Richard
OR(
IF(
AND(
OR(
PE_company__c = FALSE ,
PE_Portfolio_Company__c = FALSE
) ,
OR(
CONTAINS(LinkedIn_Company_Size__c ,'Self-employed') ,
CONTAINS(LinkedIn_Company_Size__c ,'2-10 employees') ,
CONTAINS(LinkedIn_Company_Size__c ,'N/A') ,
CONTAINS(LinkedIn_Company_Size__c ,'')
)
) ,
'0.5' , '0'
) ,
IF(
OR(
AND(
Years_of_work_exp__c >= 8 ,
NOT(
OR(
CONTAINS(LinkedIn_Company_Size__c ,'Self-employed') ,
CONTAINS(LinkedIn_Company_Size__c ,'2-10 employees') ,
CONTAINS(LinkedIn_Company_Size__c ,'11-50 employees') ,
CONTAINS(LinkedIn_Company_Size__c ,'N/A') ,
CONTAINS(LinkedIn_Company_Size__c ,'')
)
)
) ,
OR(
CONTAINS( Current_Title__c , 'director') ,
CONTAINS( Current_Title__c , 'vice president') ,
CONTAINS( Current_Title__c , 'president') ,
CONTAINS( Current_Title__c , 'general manager') ,
CONTAINS( Current_Title__c , 'chief') ,
CONTAINS( Current_Title__c , 'officer') ,
CONTAINS( Current_Title__c , 'CEO') ,
CONTAINS( Current_Title__c , 'COO') ,
CONTAINS( Current_Title__c , 'CSO') ,
CONTAINS( Current_Title__c , 'CTO') ,
CONTAINS( Current_Title__c , 'CFO') ,
CONTAINS( Current_Title__c , 'CHRO') ,
CONTAINS( Current_Title__c , 'SVP') ,
CONTAINS( Current_Title__c , 'EVP')
)
) ,
'1', '0'
) ,
IF(
AND(
OR(
PE_company__c = TRUE ,
PE_Portfolio_Company__c = TRUE
) ,
OR(
Years_of_work_exp__c >= 8 ,
CONTAINS( Current_Title__c , 'managing director') ,
CONTAINS( Current_Title__c , 'principal') ,
CONTAINS( Current_Title__c , 'vice president') ,
CONTAINS( Current_Title__c , 'president') ,
CONTAINS( Current_Title__c , 'vp') ,
CONTAINS( Current_Title__c , 'operating') ,
CONTAINS( Current_Title__c , 'partner') ,
CONTAINS( Current_Title__c , 'executive') ,
CONTAINS( Current_Title__c , 'chief') ,
CONTAINS( Current_Title__c , 'general manager') ,
CONTAINS( Current_Title__c , 'officer') ,
CONTAINS( Current_Title__c , 'CEO') ,
CONTAINS( Current_Title__c , 'COO') ,
CONTAINS( Current_Title__c , 'CSO') ,
CONTAINS( Current_Title__c , 'CTO') ,
CONTAINS( Current_Title__c , 'CFO') ,
CONTAINS( Current_Title__c , 'CHRO') ,
CONTAINS( Current_Title__c , 'Director') ,
CONTAINS( Current_Title__c , 'Portfolio operations') ,
CONTAINS( Current_Title__c , 'Talent') ,
CONTAINS( Current_Title__c , 'Chief talent officer') ,
CONTAINS( Current_Title__c , 'Head of HR') ,
CONTAINS( Current_Title__c , 'SVP') ,
CONTAINS( Current_Title__c , 'EVP')
)
) ,
'2', '0'
)
)
Thanks,
Richard
The first IF (condition1) can return '0.5' or '0' that are strings.
That could work if that was TRUE, FALSE instead of '0.5' , '0'.
OR ( IF ( ... ) , IF ( ... ) ) is equivalent to IF ( ... ) || IF ( ... ) and only returns TRUE or FALSE ( boolean, checkbox type ).
You need to use nested IF.
IF ( condition1, result1, IF ( condition2, result2, IF (condition3, result3, <default value> ))) : can return a boolean, a string or a date, etc.
All Answers
The first IF (condition1) can return '0.5' or '0' that are strings.
That could work if that was TRUE, FALSE instead of '0.5' , '0'.
OR ( IF ( ... ) , IF ( ... ) ) is equivalent to IF ( ... ) || IF ( ... ) and only returns TRUE or FALSE ( boolean, checkbox type ).
You need to use nested IF.
IF ( condition1, result1, IF ( condition2, result2, IF (condition3, result3, <default value> ))) : can return a boolean, a string or a date, etc.
I have understood your problem and also found a mistake. Firstly I didn't get, what you want with this formula? What do you expect the output?
Here all three arguments returns Text format but OR() function wants boolean type. That's why you
are getting the error:
Error: Incorrect parameter type for function 'OR()'. Expected Boolean, received Text"
You should change the return values accordingly.
If you have more queries, then feel free to ask.
I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks and Regards,
Ajay Dubedi
www.ajaydubedi.com