4 Replies Latest reply on Sep 7, 2010 10:35 AM by denno

    calc field that looks for text contained in another field?

    denno

      Title

      calc field that looks for text contained in another field?

      Post

      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?

      Thanks!