Display Text IF Another Field Contains Specific Text
I want one field to be blank in some records and then display text in others that have a particular word in another field.
"IF (some field) = "(some text)" THEN display "(other text)" in (some other field).
I have been trying with calculation fields but no luck.
Any ideas ?