6 Replies Latest reply: Dec 28, 2016 3:20 AM by sravanthi aluvala RSS

    Using IF condition in Text box

    syed quadri

      Hello friends,

       

      I need your help in what seem to be easy and straightforward yet i am not able to do it. I am trying to create a text box which how name of the market when i select an agent.

       

      for this i am doing

      ='Market: ' & Market

      and the outcome is something like Market: Alabama. Now  the problem is if the agent has multiple markets the filed goes Blank

       

      I tired using

       

      =if(Market>1, 'Multiple Markets', Market)

       

      But nothing works. Please help me out with this.

       

      I really appreciate all your help and support.

       

      Thank you,

      Syed.