Calculated Fields with "contains" condition

Hello!

I have a quick question about the new linked field calculated field ability.

Is there any condition I can use for a if a text field contains another text?

Example if({content}=“Rough Anim”)

but not as an exact match- just a contains function.

Thanks,

-Phil F

Also found out calculated fields have a character limit. Makes it impossible to do anything beyond very simple calc fields. :confused: