If Yes in one cell, Then automate No in two other cells

Hi Im trying to create a IF condition where in a dropdown list if "Yes" is selected, the No is selected in two anther dropdown lists.

The content of the dropdown list is coming from a lookup sheet. I'm getting error messages that the content is restricted but the Source is a selection within the lookup sheet. I wish I could post a picture but here the details:

Data Validation criteria is a List: "Yes", "No", "NA."

I have three locations with this data validation criteria that I would like to set a condition that if one of these locations is equal to "Yes" the other two location are equal to "No."

I was trying to do this in Conditional Formatting but any help would be great.

Thanks

It looks like you might be trying to add the IF to the field with the drop down. It should go in the field where you want the "NO" to go.

Let's say you have the drop down in cell H21 and you want the NO in cell J21. Your IF would look something like this:

=IF(H21="Yes", "No","")

It's really that simple. Just put that the two places you want the NO to appear

Thanks for the reply. I try that string but it didnt work. I get an error message that "The value is not valid. A user has restricted values that can be entered into the cell." I have a lookup sheet defining the validation list (Yes, No, N/A) and I need a way to get around this error. Is this possible, I don't know.

I tried changing the validation source to eliminate the lookup sheet but I don't know how to write a formula that would provide the functions for the use of 'Yes" in the validation source field.

Can you attach your spreadsheet? I could add the function and re-attach it

Help. I don't see how to attach an attachment on this thread.

Take a look just below the field where you type your words. On the right, click on "Go Advanced". That will allow you to attach the spreadsheet

See attachment, and reference validation list in section 2.3 Categorization.

SmartForm2_Example.xlsx

OK, I have it and I'm looking at it. I have some questions.

It looks like your fields for YES are in cells D7:D10. Do you want your NOs in cells F7:F9?

The user should have a choice of "Yes" or "No" in cells D7:D10, and the same for cells F7:F9. My issue is; I want to restrict the ability to select Yes for more than one cell between D7:D10, and the same for F7:F9. Also, if "Yes" is selected in one cell the other cells should be set to No. I hope that helps.

Thanks

I am thoroughly confused. So if the user selects YES in the cells D7:D10 you want the corresponding cells in F7:F9 to say NO? Do you really need the validation list in F7:F9? Sorry, I'm confused

It works, thanks so much