Admin: validation rules
Use Excel column letters such as A, B, AA, or exact header names from row 1.
Logic: rules in the same group are joined with OR. Different groups are joined with AND.
A conditional rule uses two IF conditions joined with AND, followed by one required THEN result.
Add rule
Existing rules
Conditional examples
- If X = A and Y = B, then Z must be empty: choose Conditional; set the first condition to X = Value A, the second to Y = Value B, and the result to Z is empty.
- If X is not empty and Y > 0, then Z must be Approved: choose Conditional; set X to is not empty, Y > Value 0, and Z = Value Approved.