Skip to main content
Clare Hayward 님이 #Data Management에 질문했습니다
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일 오후 1: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")