How to enable Data Validation

​

Value

Set rules for data entry to prevent input errors, standardize formats, and improve data collection accuracy and efficiency.

​

Use cases

When Team Users collaborate on filling in a Spreadsheet, not everyone may be familiar with the entry requirements, which often leads to input errors. Manual review is time-consuming and labor-intensive. With the Data Validation feature, you can predefine entry rules to standardize formats, prevent errors, and improve both the accuracy and efficiency of Data collection.

​

Instructions

Entry points:

1. Top menu — Data — Data Validation.
2. Toolbar — Data Validation.
3. Right-click menu — Set Data Validation.

Settings:

1. Open one of the entry points and click Create rule.
2. Configure the rule: select the desired data Type and validation rules (input Tips and Error Warning).

(Data Validation is a compatibility feature. The rules are consistent with local Actions, but some UI interactions may differ.)

3. Click Confirm to Save.

Validation:

1. Based on the predefined rules, other Users will see input Tips when they click the Cell.
2. If the entered Data does not match the predefined rule, an invalid Data message will appear.

---

Back to Spreadsheet