Formula (Extended): $FIND 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 case-sensitive. Wildcard characters cannot be used.

Syntax¶

$FIND(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 greater).
An error occurs if the search string is not found.
An error occurs if the start position is greater than the number of characters in the target string.

Return Value Display Content¶

Target	Display Content of 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