I need help with the following: I have 2 columns in a list and when "Yes" is selected in column 1, then "Yes" must be selected in column 2 also

What I need is:

If [column 1]="Yes", then [column 2] must be "Yes".

in other words, If [column 1]="No", then [column 2] can be "No" or "Not Applicable")

It would be great if anyone could help me with the right formula.

  • What is the data type of your columns? Choice or Boolean (Yes/No)/anything else? Mar 4, 2020 at 10:52
  • And what you want to do If [column 1]="No"? Can [column 2] be anything in this case or it should only be either "No" or "Not Applicable" (and not "Yes")? Mar 4, 2020 at 10:57
  • Column 1 is a choice to force the users to select the right answer and not leave it default. if they select no in column 1, they can select anything in column 2. I put your formula and it works!
    – Simona M
    Mar 4, 2020 at 11:19

1 Answer 1


Try using below formula:

=IF([column 1]="Yes",IF([column 2]="Yes",TRUE,FALSE),TRUE)

This will satisfy the condition: If [column 1]="Yes", then [column 2] must be "Yes".


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.