This content has been marked as final. Show 5 replies
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