calc field that looks for text contained in another field?
I am trying to create a field that displays a message if another field with a checkbox set contains a specific string (i.e., if a checkbox is set). I thought I would just create a calc field that looks like
If ( Conclusion = "ED Clinical Issues Meeting discussion" ; "Clinical Issues discussion needed" ; "" )
but this only works if [ED Clinical Issues Meeting discussion] is the only checkbox checked--I need it to work even if other choices are set in addition to this one. Doesn't look like calc fields accept wildcards--any other way to do it?