How to Use WPS Formula on macOS

Last updated:July 21, 2026

Use Formula through 3 how-to topics, all available without membership; choose a topic from the index and follow the entry path and steps below.

How-to Index

No.TopicMembership Requirement
11. Open the Formula entryFree
22. Set formula parameters and saveFree
33. Edit an existing formula and confirm againFree

How-to Guide

1. Open the Formula entry

Entry path: Form editor → Form → Formula

  1. Open the smart form that you want to edit.
  2. In the left navigation pane, select Form.
  3. Find Formula and click it.
  4. Wait for the formula editor area or settings panel to open.

Success Criteria

  • Interface result: The formula editing area or settings panel is open.
  • What you can do next: You can continue to set parameters or review existing settings.

Tips While Using

  • Common mistake: If you are not in the form editing view, the Formula entry may not appear.
  • Environment note: If the form is stored in an online collaboration space, keep your network connection active.

2. Set formula parameters and save

Entry path: Formula panel → Parameter settings → Confirm

  1. Enter or adjust the required parameters in the Formula panel.
  2. Check the formula logic based on the on-screen prompts.
  3. Use the preview or result area to confirm the effect.
  4. Click Confirm to finish the setup.

Success Criteria

  • Interface result: The panel closes or the current configuration is recorded successfully.
  • What you can do next: You can continue editing other parts of the form or move on to saving and publishing.

Tips While Using

  • Common mistake: Closing the panel before confirming may leave the current changes unsaved.
  • Environment note: For complex forms, preview the result before moving on.

3. Edit an existing formula and confirm again

Entry path: Form editor → Form → Formula

  1. Reopen Formula in the target form.
  2. Find the formula content that you want to adjust and edit it.
  3. Preview the result again and confirm that the updated logic works as expected.
  4. Click Confirm or save the related settings.

Success Criteria

  • Interface result: The updated formula takes effect and shows the latest result.
  • What you can do next: You can continue maintaining the form or prepare to publish an updated version.

Tips While Using

  • Common mistake: Skipping the second result check after editing may cause linked field changes to be missed.
  • Environment note: Some changes may appear to respondents only after the form is published again.