SharePoint Column Validation

Question

Hello!

I have a list where items are submitted. I have two columns specifically that potentially need to be used in the column validation. I have tried all the formulas I could think of, and the formulas do not work. I am wondering if I am missing something crucial in the capabilities of the column validation field. My two columns the first one is a "Yes/No (check box)" and the other with the option of column validation is a number field. The logic is if the yes/no column is checked "Yes", and the number field is left blank there would be an error message that would pop up and remind them to put a number in the number field or uncheck the yes box. I added my screen shots but not sure if all 4 of them were able to upload. I know there is a solution to this but it has to error out with this specific situation. All the other situations have to let the requestor run through the submission process.

Thanks,

Sarah George

Answer 1

Hi Sarah,

If you have any issues trying my steps, or if my formula doesn't work for you, please post back and let us know. We will continue to help you.

If my formula and steps help, please send feedback on my reply. It will help other members who have the same concern.

Sincerely, 

George | Microsoft Community Moderator

Answer 2

Hi Sarah,

Since your screenshot was not successfully uploaded, I don't know your steps and your formula. Please check if your steps are the same as below and tried the following formula.

I created a Number column called "Number" and created a Yes/No column called "Yes/No"

1. If you need to reference another column, you can't build the formula in column validation, you should build it in the list validation.

Go to the list, click Settings> List settings> Validation Settings.

2. Try the following formula and enter the related message.

=OR(NOT([Yes/No]),AND([Yes/No],NOT(ISBLANK([Number]))))

![Image](https://learn-attachment.microsoft.com/api/attachments/ce1e6166-3970-486d-8cfc-636af4f5f45d?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/4bdcc239-45e9-4b39-a4a1-35542411facd?platform=QnA" rel="ugc nofollow">

We look forward to your response. Thanks for your cooperation.

Sincerely, 

George | Microsoft Community Moderator

Answer 3

Hi Sarah,

Thanks for posting in the community. We are happy to help you.

From your situation,we need to do some tests first on our side, we'll appreciate it if you can understand that it will take some time to give you more effective suggestions according to the test result. We will update our reply as soon as possible.

Thanks again for your understanding and cooperation.

Sincerely, 

George | Microsoft Community Moderator

Answer 4

This worked!! Thank you so much for the fast response!