WPS Formula on Windows: Introduction

WPS Formula is a formula setup feature in Smart Forms questionnaires; it includes 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

Formula is used in the Questionnaire area of Smart Forms to set up and manage formulas during form design. After you open the form editor, you can go to the Questionnaire section, open the Formula panel, adjust related settings, preview the result, and confirm the configuration.

Core tasks include:

Open the Formula entry in the questionnaire editor.
Set formula parameters in the configuration panel.
Preview the current formula result before saving.
Confirm and save the configuration.

This feature is useful for questionnaire score calculation, result aggregation, pre-release logic checks, and updates to existing form rules.

System Requirements

Item	Requirement
Operating system	A Windows PC that can run the WPS Office desktop app
App version	It is recommended to use the latest version of WPS Office
Network	An internet connection is recommended when opening online forms or syncing form data
Other	Sign in to your WPS account and make sure you have edit permission for the current form

Download & Installation

Before you use Formula, install WPS Office on your Windows device and open an editable Smart Form.

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, enter the Smart Form editor, and confirm that the Formula entry is available in the Questionnaire section

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides a Formula entry inside Smart Forms questionnaires, where you can open the panel, set parameters, preview the result, and confirm the setup.	Microsoft Forms officially documents branching logic that routes respondents to later questions. The official page does not describe a native formula field setup flow in the form editor.	Google Forms officially documents response rules and validation. Official help also shows that responses can be analyzed in Google Sheets, but the form editor documentation does not present native calculated fields in the same setup flow.	Notion Forms are connected to databases, and formulas are handled through database formula properties rather than as in-form calculation fields.	Adobe Acrobat supports calculation fields in PDF forms, including predefined calculations and field-based calculation setup.
WPS Advantages	Advantage: the Formula entry is part of the questionnaire editing flow. Distinct: parameter setup, preview, and confirmation are handled in one editing path.	Compared with WPS: Microsoft's official Forms guidance focuses on branching between consecutive questions instead of a dedicated formula setup panel.	Compared with WPS: Google's official Forms guidance emphasizes validation and Sheets-based analysis, rather than a built-in formula configuration panel in the form editor.	Compared with WPS: Notion separates form collection from database formula properties, so formula setup happens at the database layer.	Compared with WPS: Adobe's calculation workflow is centered on PDF form fields, which fits document forms rather than questionnaire editing.
Official Source	—	Use branching logic in Microsoft Forms	How to set rules for your form	Forms; Intro to formulas	Configure form field calculations in Acrobat

Overall Conclusion: WPS keeps formula setup close to the questionnaire editing workflow, which is convenient when you want to configure, preview, and confirm logic in one place. Other products provide related capabilities, but they are centered on branching, validation, database formulas, or PDF form fields.

Use Cases

No.	Scenario	Suitable For	Main Need	How Formula Helps
1	Questionnaire score setup	Form designers	They need to define calculation rules before publishing	Open Formula in the Questionnaire section and set the needed parameters
2	Result preview before release	Operations and research teams	They want to check the effect before saving	Preview the formula result before confirming
3	Logic review before publishing	Form administrators	They want to reduce setup mistakes	Review the preview result and then save the configuration
4	Updating existing rules	Form maintainers	They need to revise an existing formula setup	Reopen the Formula panel, adjust the settings, and save again
5	Organizing multi-question logic	Business users	They need a more centralized setup path	Use the Formula entry to manage related settings in one place

Membership & Benefits

Free vs WPS Premium

The feature description marks Formula as available without membership. The official pricing page also shows that WPS offers a free plan and paid plans with additional PDF, AI, template, and cloud storage benefits.

Capability	Free Users	WPS Premium
Formula setup in Smart Forms	✅ Available	✅ Available
Core office apps	✅ Available	✅ Available
More PDF and advanced tools	Some items may be limited based on the product page	✅ More items available
Cloud storage and extra benefits	Basic allocation	Higher allocation or more benefits

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
You only need to configure Formula in questionnaires	Free	The feature is available without membership for the workflow described here
You also need more PDF, AI, or added office benefits	WPS Premium	A paid plan is more suitable when you need broader office and value-added features

WPS membership center: Subscribe now