Calculation Field "If" Question

[ErikP]

I'm trying to create a calculation field using FM5.5 that will return one of two values based on the value of another field.

The art department requests ink samples from the ink lab and assigns the ink a temporary formula name of "TBD1234". Once the ink lab formulates the ink, the formula name is updated and the "TBD" portion is removed.

I'm trying to create a calc field like so:

If(Formula Field = "TBD"*, "FORMULATE", "COMPLETED")

Unfortunately the asterisk character doesn't return anything. Is this possible?

[danjacoby]

Use the PatternCount function to determine if "TBD" is a part of that field.

[Lee Smith]

Hi Dan and Erik,

I didn't have any luck structuring the If Statement, but this Case works.

Case(PatternCount(Formula Field, "TBA"), "FORMULATE", "COMPLETED")

HTH

Lee

[ErikP]

Lee,

Case calc worked great!

Many thanks.

Erik