user2680039
user2680039

Reputation: 99

Limit a table's cell's values to two values?

I have a two-column table but I want all values in the first table to be either X or Y, and no other input should be allowed. How can I enforce this?

Upvotes: 0

Views: 293

Answers (2)

Declan_K
Declan_K

Reputation: 6826

You can use a validation rule.

Restrict data input by using a validation rule

A Validation Rule on the column as follows will work.

="X" Or ="Y"

Upvotes: 2

Adriaan Stander
Adriaan Stander

Reputation: 166476

You might want to look at

  1. Create a validation rule to validate data in a field
  2. Validation rules

Upvotes: 0

Related Questions