LOWER in WPS on Windows FAQ

Last updated:July 23, 2026

Common LOWER questions usually focus on errors, nested formulas, and result updates; this section covers 3 frequent questions.

FAQ

What should I check if LOWER returns an error?

  1. Check whether the formula syntax is complete and whether parentheses and parameter positions are correct.
  2. Check whether the referenced content is a text field or a text result that should be processed.
  3. Revise the parameter based on the editor prompt, then save the formula again.

Can LOWER be used with other functions?

  1. Decide what the outer or inner function should handle first.
  2. Place LOWER into the combined formula as the text-processing step.
  3. Save the formula and confirm that the combined result matches your goal.

Does LOWER update automatically after data import?

  1. After the formula field is saved, it calculates based on the current data.
  2. When source data changes, check whether the formula field refreshes accordingly.
  3. If the result does not update, review the field reference and formula structure again.

Glossary

TermDefinition
LOWERA function that converts letters in text to lowercase.
Formula fieldA field type in Bitable that calculates results automatically with a formula.
ParameterThe value passed into a function, such as text, a field value, or a reference result.