We have an Excel sheet with a filter on a specific column. The values in the filter for this column are "Purchase" and "collection".
I want my users to be able to choose 1 of these 2 options in this column when they create a new row. Sort of like a little checklist of options.
This will combat typo's and other issues.
Does anyone know how to do this?