Feature Summary

When you need to write formulas based on data logic in Sheets, Sheets AI Formula can understand your calculation intent and automatically generate the correct formula, helping you easily complete common calculation tasks such as summing, counting, and searching.

Feature Description

Feature Dimension Description
Membership Limits Available for both WPS Pro+ and WPS Premium
Version Limits Applicable to the latest version on the WPS official website

Operating Steps

Sheets AI Formula

Feature Entry ①
Enter an equal sign in a cell → Dropdown menu → "AI Formula"

  1. Select the target cell.
  2. Enter the "=" sign.
  3. Find "AI Formula" at the bottom of the pop-up function dropdown menu.
  4. Click to enter the AI Formula input box.

PixPin_2026-09-17_16-19-03

Feature Entry ②
"fx" button → Insert Function → "AI Formula"

  1. Select the target cell.
  2. Click the "fx" button on the left side of the formula bar.
  3. Open the Insert Function dialog box.
  4. Click the "AI Formula" link at the bottom.

PixPin_2026-09-17_16-19-17

Enter Formula Requirements

Feature Entry
AI Formula input box

  1. Describe your formula requirements in natural language in the input box (e.g., "add column B and column C").
  2. A "DeepThink" option is provided at the bottom (can be enabled when processing complex formulas).
  3. Click the Send button on the right to submit your requirements.

PixPin_2026-09-17_16-20-42

Confirm Formula Results

Feature Entry
Formula generation result interface

  1. After AI generation is complete, the calculation results and formula are displayed.

  2. The thinking process is displayed (e.g., "Thinking: 2s").

  3. The formula bar displays the generated formula (e.g., "=B1+C1").

  4. Three actions are provided at the bottom:

    • "Ask Again": Modify requirements and regenerate.
    • "Discard": Close the formula without using it.
    • "Done" (SlateGray button): Confirm to use the formula.

  5. A note at the bottom states: "AI-generated information is for reference only. Please verify its accuracy."

PixPin_2026-09-17_16-21-14

FAQ

Question 1: What calculation types does Sheets AI Formula support?

  • Solution: It supports common formula requirements such as sum, count, lookup, and conditional calculations. You can describe them in natural language, and the AI will automatically generate the corresponding formula.

Question 2: Can the generated formula be modified?

  • Solution: Yes. After clicking "Done", the formula will be applied to the cell, and you can manually modify it in the formula bar. You can also click "Ask Again" to regenerate.

Question 3: What should I do if the generated complex formula is inaccurate?

  • Solution: Enable "DeepThink" mode for deeper AI analysis. It is also recommended to use more detailed descriptions to express your requirements.

Notes

  • There is no limit on the number of times WPS Plus and Premium members can use the Sheets AI Formula feature.
  • Generated formulas are for reference only. We recommend checking them before use.
  • For complex formulas, we recommend enabling "DeepThink" mode to improve accuracy.
  • Cell references in formulas are highlighted in color for easy verification.