## 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 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 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. | |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 the parameter by the screen column name (name displayed)  ### Parameters  ### Calculation Result  ## Usage Example ② Specify the parameter [start position] ### Formula  ### Parameters  ### Calculation Result