Skip to main content
Topics#Data ManagementPeter Cowen's Question
Peter Cowen (selenity) asked in #Data Management
Nov 21, 2016, 10:47 PM

formula to check multiple fields

is it possible to have a formula that checks multiple fields to display an image for example I would like field a = 1 and if field2 = 2 display an image else check if field1 and field3 
4 answers
  1. Martin Keating (Snap Inc. (Snapchat))
    Nov 21, 2016, 11:02 PM
    Sure, you can use nested IF statements like so:

     

     

    IF(
        condition1,
        outcome if true, 
        outcome if false)

    Then replace your outcome if false like so:

    IF(
        condition1, 
        outcome if true, 
        IF( 
            condition2,
            outcome if true, 
            outcome if false))

     

    So for you it would be something like:

     

     

    IF(
        AND(
            field_a__c = 1, 
            field_b__c = 2),
        display an image, 
        IF( 
            AND(
                something with field_1__c, 
                something with field_3__c), 
            outcome if true, 
            outcome if false))
Write an answer...
0/9000