have an issue with this below formula, cant seem to find the root cause. The error says Error: Syntax error. Extra ','
If(TEXT(Test.Cold.Type__c) = '' || ISPICKVAL(Sale__r.Test__c, 'Sold') || TEXT(Test.Cold.Type_Set__c) = ''),0,1)
Here the first Text(Test.Cold.Type__C) is a picklist field and TEXT(Test.Cold.Type_Set__c) is a text field. I got this error when I added the last condition.
Coming back to this again, what could be the reason for the first condition not to work when adding the last condition. I am not sure how to get out of this frustrating issue -
If I just do
If(TEXT(Test.Cold.Type__c) = '' || ISPICKVAL(Sale__r.Test__c, 'Sold'),0,1)
it works, but when I add the third condition which is (Test.Cold.Type_Set__c='') the first one does not work. I guess I have tried my best so far.