Skip to main content
This is my existing formula.

 

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 件の回答
  1. 2014年7月29日 13:54
    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")