How to Use the FIND Function in WPS on Windows

Last updated:July 23, 2026

Use FIND through 3 how-to topics: create a formula field, enter the function in the required format, and review the calculated result; 3 topics are free and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and call FINDFree
22. Enter FIND with the required parameter formatFree
33. Review and reuse the calculated resultFree

How-to Guide

1. Create a formula field and call FIND

Entry: Add Field → Formula

  1. Open the Bitable you want to edit.
  2. Click Add Field.
  3. Select Formula as the field type.
  4. Prepare to enter a FIND formula in the formula editor.
  5. Click confirm or save to enter formula editing mode.

Success Criteria

  • Interface result: A new formula field appears in the table.
  • Next action available: You can enter FIND and other functions in the formula editor.

Tips While Using

  • Common mistake: If you choose another field type, you cannot enter a formula directly.
  • Environment note: You need permission to edit the current Bitable structure.

2. Enter FIND with the required parameter format

Entry: Formula Editor → Function Input Area

  1. Type FIND( in the formula editor.
  2. Fill in the required parameters as needed.
  3. Use the following format as a reference:
FIND(
  [parameter1],
  [parameter2],
  ...
)
  1. Add the target data range or condition content required by your formula.
  2. Check parentheses, commas, and references, then save the formula.

Success Criteria

  • Interface result: The formula editor shows a complete FIND formula.
  • Next action available: After saving, the system starts calculating and returns a result.

Tips While Using

  • Common mistake: Incorrect parameter order or bracket format can prevent the formula from calculating correctly.
  • Environment note: Referenced field names must match the actual field names in the table.

3. Review and reuse the calculated result

Entry: Formula Field Result Column

  1. Save the formula and return to the data table.
  2. Review the formula field result for each record.
  3. Confirm that the result refreshes automatically when source data changes.
  4. If you need more logic, continue combining FIND with other functions.

Success Criteria

  • Interface result: The formula field displays the calculated numeric result.
  • Next action available: After source fields change, the result updates accordingly.

Tips While Using

  • Common mistake: If the referenced content does not match the expected text, the result may return an error or an unexpected value.
  • Environment note: A formula field is a calculated field, so its result is generated automatically by the formula.