Validation Rules

Column-Level Validation

  • Primary Keys: Must have values, cannot be empty
  • Data Types: Numbers must be numeric, Yes/No must be "Yes" or "No"
  • Allow Empty: If "No", values must be provided
  • Column Names: Must be non-empty and unique

Value Column Validation

  • Valid (Green): All cells in the column pass validation
  • Invalid (Red): At least one invalid cell exists