5 Replies Latest reply: Mar 31, 2017 1:49 AM by Taahir Hoosen RSS

    If statement in a text box based on selection of field

    Taahir Hoosen



      I would like to know is it possible to create a text box with conditional text.


      my text box has a campaign selection field as an input as below:


      = ,'Online Sales Report for ' & [CAMPAIGN]  & ' ' & [Year])


      but when there is no selection, it shows "Online Sales report for"..... I would like to make this text box conditional so that when there is no selection it remains blank


      = if(CAMPAIGN = '' ,'','Online Sales Report ' & [CAMPAIGN]  & ' ' & [Year])


      I am using the above statement but it does not seem to work