
IF (OR(ISPICKVAL( Downloaded_File_ID__c , "41"), CONTAINS(Additional_Downloads_IDs_TEXT__c , "41") ), "yes", "no")
The ID of the file can now be either 41 or 548, how do I amend my existing formula so that it checks both fields for either 41 or 548 and return true if it finds either/both?
4 réponses
Try: IF(
OR(ISPICKVAL( Downloaded_File_ID__c , "41"),
ISPICKVAL( Downloaded_File__ID__c, "548"),
CONTAINS(Additional_Downloads_IDs_TEXT__c , "41"),
CONTAINS(Additional_Downloads_IDs_TEXT__c, "548")), "yes", "no")