3 Replies Latest reply: Jul 16, 2018 12:44 PM by Mahitha M RSS

    Create new field with if logic

    Mahitha M

      Hi Experts,

       

      Can any one please help me to create a new field called

      Section with records 'Electronics Section', 'Clothes Section', 'Vehicles Section' from Product, Clothes and Vehicles fields

      based on below conditions.

       

      if [Product] is TV,Refrigerator then its  'Electronics Section'

      if [Clothes] is Cotton and [Brand] is Asian,Raymond, Allen Solly then its 'Clothes Section'

      if [Vehicles] is Car, Bike and Type is Tata,Maruthi then its 'Vehicles Section'

       

      Please help me on this.

       

      Thanks in advance.