Finding text in a field
I would like to have a field that notifies if another field contains a certain word. For example I can use:
"Sample Field" calculation is If(Field A="test",yes)
But if Field A a contains, "test today" the Sample Field will be blank. How do I get it to still show "yes"?