AnsweredAssumed Answered

calc field that looks for text contained in another field?

Question asked by denno on Sep 7, 2010
Latest reply on Sep 7, 2010 by 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!

Outcomes