2 Replies Latest reply on Sep 24, 2018 11:07 AM by meenu choudhary

    If And Contains formula help


      I want to say:


      1. IF Field "Status" value is not equal to "Outdoor"

      2. AND Field1 string contains either of "Cat", "Dog", "Mouse" or "Fish" OR Field2 string contains "bird"

      3. Call it "Pet" otherwise "Other"


      Help greatly appreciated.