## 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 numerical 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|Numerical 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 dropdown list with values, the options that match the return value are displayed. | |Numerical 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 | ## Usage Example ① Specify parameters by screen column name (name displayed) ### Formula  ### Parameters  ### Calculation Result  ## Usage Example ② Specify the parameter [Start Position] ### Calculation formula  ### Parameters  ### Calculation Result