WPS Formula on macOS: Introduction

Last updated:July 21, 2026

WPS Formula is a formula setup feature for smart form relay workflows; it includes 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

MetricValueNotes
Core tasks3Matches the number of rows in the How-to Index
Available without membership3Matches the number of Free rows in the index
Membership-related items0All listed tasks are available directly

About This Feature

Overview

Formula is a configuration feature in WPS Office for Mac smart form relay workflows. It is used to set up and manage formula rules while creating a relay-based form process.

Its main capabilities include:

  • Open the formula setup entry from the form editor and relay module.
  • Set parameters and preview the result in the configuration panel.
  • Save the formula settings so later relay activity follows the updated rules.

This feature is useful when you want to define calculation logic before collecting responses, organizing relay tasks, or standardizing follow-up data handling.

System Requirements

ItemRequirement
Operating systemA Mac device that can run WPS Office normally
App versionIt is recommended to use the latest version of WPS Office for Mac
NetworkAn internet connection is recommended for download, sign-in, sync, or publishing
OtherYou need access to the smart form editor and permission to edit the current form

Download & Installation

ItemDetails
Official downloadWPS Office Free Download
Check after installationOpen WPS Office for Mac, enter the smart form editor, and confirm that the Relay and Formula entries are available

Source: WPS download page

Compare with Alternatives

DimensionWPSMicrosoftGoogleNotionAdobe
Capability SummaryProvides a formula setup entry inside smart form relay workflows, so you can configure, preview, and save rules during form creation.Excel supports formulas that begin with an equal sign and can use functions, references, and operators for calculations.Google Sheets supports formulas and functions in cells, including range selection and nested functions.Notion formulas are mainly used for database properties and return results based on properties, built-ins, and functions.Acrobat supports calculations for PDF form fields and can apply automatic calculation rules in forms.
WPS AdvantagesAdvantage: Formula setup is built into the smart form relay flow, which is convenient when you want to define rules during form design.Compared with WPS: Focuses on spreadsheet cell formulas rather than relay-style form configuration.Compared with WPS: Focuses on spreadsheet calculation workflows in sheets and cells.Compared with WPS: Focuses on database properties instead of a dedicated relay form configuration flow.Compared with WPS: Focuses on PDF form field calculations rather than smart form relay setup.
Official SourceOverview of formulas in ExcelAdd formulas & functionsIntro to formulasConfigure form field calculations in Acrobat

Overall Conclusion

WPS Formula is closer to a smart form relay setup workflow, which makes it suitable for configuring rules during form design. Microsoft and Google focus more on spreadsheet formulas, while Notion and Adobe focus on database-property and PDF-form calculation scenarios.

Use Cases

No.ScenarioSuitable UsersMain NeedHow Formula Helps
1Preset relay rulesForm creatorsThey need to define calculation logic before publishing a relay flowOpen Formula from the Relay module and complete the setup
2Adjust and confirm parametersOperations staff or collaboratorsThey need to verify whether updated settings match expectationsEdit parameters in the panel and preview the result
3Check before publishingForm administratorsThey want to avoid missing a save step before releaseReview the setup and click Confirm to save
4Maintain rules laterExisting relay maintainersThey need to revise formula settings after creationReopen the editor and update the Formula settings
5Apply rules to new dataData collection staffThey want later entries to follow updated rulesUpdate the formula and publish the latest configuration

Membership & Benefits

Free vs WPS Premium

CapabilityFreeWPS Premium
Writer, Spreadsheet, and Presentation core apps✅ Available✅ Available
Basic Formula setup for this workflow✅ Available✅ Available
Advanced PDF editing and some advanced toolsDepends on the feature✅ More advanced tools available
Cloud storage and multi-user sharing benefitsBasic quotaHigher quota or more extended benefits
AI and some advanced toolsSome limits may applyBroader access may be available

Source: WPS Office pricing page

Recommendations

ScenarioRecommended PlanWhy
Occasional relay formula setup or editsFreeThe current Formula workflow does not show a membership requirement
Need more PDF, AI, or extended benefitsWPS PremiumSuitable when you also need more advanced tools and expanded benefits
Team collaboration and shared useChoose based on your subscription needsHelps align storage, accounts, and collaboration needs

How to Subscribe

Source: WPS Office pricing page