Help with IF Statement text box

[ivandrago]

Hi,

I have the attached Document, I want the text box to show the word 'Open and Closed', this will only appear when the Status Open and Closed is selected.

Thanks

[swuehl · Accepted solution]

If you want to stay close to your current idea, you can use

=If(Match(GetFieldSelections( Status),'Closed, Open'),'Open and Closed: ')

to get the text printed if both values are selected, or

=If(Match( Status,'Closed','Open'),'Open or Closed: ')

will print the text if either Open or Closed is selected, but not both.

Hope this helps,

Stefan