Forum Discussion
Why isn't my Validation Settings formula working?
Unfortulately, SharePoint validation (or calculated column) formulas don't support the choice columns with multiple selection allowed.
So, you cannot achieve it using the list validation settings.
If you are using SharePoint Online list, you can achieve it by customizing list forms using Power Apps and using Power Apps formulas to apply validation before submitting the form. Check: Customize a Microsoft Lists or SharePoint form by using Power Apps
Also, for any SharePoint service related bugs/issues you can reach out to Microsoft support directly by following: Get M365 support - online support
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
ganeshsanap thanks for the input. 1 - I'm not getting any error messages, it's simply not applying when I go try to test it. 2- Column type for "Feedback Response" is multiple choice from a series of text and Column Type for "Date Meeting Scheduled" is Date and Time.
That formula you provided unfortunately did not work either. Do you think it may be an issue with my SharePoint as a whole? For example, I have a list on my navigation that I've been trying to remove from my Navigation sidebar and have it checked to "No" to not appear in navigation, but no matter how many times I try to set it to "No" it continues to appear in my navigation.
Is there possibly an underlying issue here with my SharePoint? Do you know who I could reach out to for this or any troubleshooting I myself could do?
Unfortulately, SharePoint validation (or calculated column) formulas don't support the choice columns with multiple selection allowed.
So, you cannot achieve it using the list validation settings.
If you are using SharePoint Online list, you can achieve it by customizing list forms using Power Apps and using Power Apps formulas to apply validation before submitting the form. Check: Customize a Microsoft Lists or SharePoint form by using Power Apps
Also, for any SharePoint service related bugs/issues you can reach out to Microsoft support directly by following: Get M365 support - online support
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.