CONTAIN Function: Difference between revisions
From Planfix
(Created page with "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 I...") |
No edit summary |
||
| (3 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
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 | {{#seo: | ||
|title=CONTAIN Function | |||
|titlemode=append | |||
|keywords=planfix, function, CONTAIN, contain | |||
|description= 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:'' | ''Format:'' | ||
*'''CONTAIN(Where to look;What to look for)''' | *'''CONTAIN(Where to look;What to look for)''' | ||
| Line 22: | Line 27: | ||
In this example, the formula checks the row it was entered in to see if it finds the string "Clarification" in column H. If it does, it outputs the value in column G of this same row. If it doesn't, it returns a blank output. | In this example, the formula checks the row it was entered in to see if it finds the string "Clarification" in column H. If it does, it outputs the value in column G of this same row. If it doesn't, it returns a blank output. | ||
== Go To == | |||
*[[Standard functions | Standard operators and Planfix functions]] | |||
*[[Calculated fields]] | |||
*[[Reports]] | |||
Latest revision as of 06:57, 10 May 2024
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, the formula checks the row it was entered in to see if it finds the string "Clarification" in column H. If it does, it outputs the value in column G of this same row. If it doesn't, it returns a blank output.