Forum Discussion
MSFT Lists Custom Column Question
I'd like to add a column to this List, where the only choices are Fridays. Is there a way to configure this column to where the user will see a drop down list and must choose a Friday date?
To add a column with choices limited to Fridays, you can create a dropdown list with predefined Friday dates. In Excel, you can go to the Data tab, choose Data Validation, and set the validation criteria to "List" with Friday dates. In Google Sheets, use Data Validation under the Data menu. Users will then see a dropdown list, ensuring they select only Fridays for that column.
