Cannot access validation settings in SharePoint list settings

Question

Hi,

I am trying to add some validation to my Sharepoint list. Essentially Column A is a Yes/No column, and Column B is a date. I want to add validation so that Column B cannot be filled unless column A is ticked.

I know I can't do this in the column validation settings as I need to refer to another column.

By following online tutorials, I need to click on the gear icon > list settings > validation settings.

My problem is that when I'm in List Settings, there are no validation setting options.

Thank you for your help.

Answer 1

Hi bh21,

First, my pleasure to assist you.

As per your description, please don’t worry, we can work together to narrow down and resolve the situation.

Based on my test result, I’m able to see the “Validation settings” option in a list setting. See image below for your reference:

Since you are not able to see “Validation settings” option in your list setting, if you don’t mind (my request please don’t mind) could you please confirm what permission do you have in SharePoint online list. Based on my test result if the user have "Edit permission" cannot see “Validation settings” option in a list setting. See my image below for your reference:

Note: Because the Full Control permissions are needed for “Validation settings” option in your list setting,

Regarding to your need, "I want to add validation so that Column B cannot be filled unless column A is ticked."  If you don’t mind, could you please try to access the Validation Settings page by manually entering the URL. For example:  

 While on the list settings page, your URL will contain:

.../_layouts/listedit.aspx?List=%...

If you change this to:

.../_layouts/VldSetng.aspx?List=%...

Then you will be on the Validation Settings page for the same list.

I appreciate your understanding and stay safe!!

Best regards

Waqas Muhammad

Answer 2

Hi,

I actually just resolved this issue on my own but becoming a Site Owner.

Thank you for your help though!

Answer 3

Hi bh21,

Thanks for your valuable feedback. Glad to hear this issue has been resolved and thanks for sharing updates with us. Comments and feedback from our customers really motivate us to perform better and better and provided as much help as possible.

I appreciate your kind words.

If there is any issue related with the Office applications in the future, please feel free to post back in this community.

We will be here for help.

Have a good day and stay safe 😊

Best Regards,

Waqas Muhammad