Formula (Extended): $SEARCH Function

2023-12-062024-06-07

Overview¶

Search for the search string in the target string, and return the result by counting the position where the search string first appears from the left end. The search is not case sensitive. Wildcard characters cannot be used.

Syntax¶

$SEARCH(Search String,Target String,[Start Position])

Parameters¶

Parameter	Type	Required	Description
Search String	Arbitrary String	Required
Target String	Arbitrary String	Required
Start Position	Half-width numeric value. Integer of 1 or more	Optional	Specify the position to start the search. Specify 1 to search from the first character of the "Target String". If omitted, 1 is assumed to be specified.

Column Usable as Parameters¶

Parameter	Classification	Numeric Value	Date	Description	Check
Search string	Yes	Yes	Yes	Yes	No
Target string	Yes	Yes	Yes	Yes	No
[Start position]	Yes	Yes	No	Yes	No

Return Value¶

Position where the search string first appears (integer 1 or more).
If the search string is not found, an error occurs.
An error occurs if the start position is greater than the number of characters in the target string.

Return Value for Target Column¶

Target	Return Value
Classification (including title, status, manager, owner)	Display return value. In the case of a drop-down list with values, the options that match the return value are displayed.
Numeric Value (including work volume, progression rate, remaining work volume)	Display return value.
Date (including start and completion)	Do not display.
Description (including content)	Display return value.
Check (including lock)	Do not display.