CONTAIN Function

This function returns the Boolean value "True" if the string it's searching for is found in a report column or analyzed the field. It is usually used in conjunction with the IF Function.

Format:

• CONTAIN(Where to look;What to look for)

where:

• Where to search - search range; this is generally a report column's "code" (the letter at the top of the column, A-Z, AA-ZZ, etc.) or a custom field
• What to search for - the string that's searched for in the specified range

Example:

IF(CONTAIN(H;"Clarification");G;"")

In this example, when a user applies the formula to each row in the report, it checks whether the value in column H of that same row contains the text "Clarification." If it does, the formula returns the value from column G of that row; otherwise, it returns an empty value.

Important

• The function is case-insensitive.

Go To

• Standard operators and Planfix functions
• Calculated fields
• Reports