Data cleaning · Easy
How would you stop people entering bad data in a shared sheet?
Short answer
Use Data Validation to restrict entries to a list, number range or date range, with an input message and a clear error alert. Combine it with a structured Table, locked formula cells and sheet protection, so collaborators can enter data only where intended.
Detailed answer
Dropdown from a list: Data Validation › List › =Lists[status]. Keep the list in a Table so it grows automatically.