Good evening to all!
I'm trying to figure out why a syntax-correct Checkbox formula is returning an #Error when it encounters a True result, but a correct empty checkbox when encountering a False result.
The formula's purpose being to ensure that only Meeting records created by certain Roles, assigned to certain Role holders, bearing specific criteria and being of a certain Record Type will be counted as True.
The formula is as follows:
IF( OR( Owner:User.UserRoleId = '00E70000001EIHY', Owner:User.UserRoleId = '00E70000001BIgq') && OR( CreatedBy.UserRoleId = '00E70000001EIHT', CreatedBy.UserRoleId = '00E70000001EIHS') && ISPICKVAL(CallType,"Meeting") = True && OR( ISBLANK(TEXT(Call_Result__c)) = True, AND( ISBLANK(TEXT(Call_Result__c)) = False, TEXT(Call_Result__c) <> "Cancelled per client" ) ) && OR( RecordType.Id = '012700000001kKq', RecordType.Id = '012700000001kKr', RecordType.Id = '012700000001kKs') ,TRUE ,FALSE )
The code is syntax correct and is displaying results, just not valid results.
What am I missing? Is there an open-ended line that is causing some sort of invalidation in the True?
Thank you and all the best.