SharePoint list validation formula

Question

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? — Ganesh Sanap - MVP, Commented 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")? — Ganesh Sanap - MVP, Commented 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, Commented Mar 4, 2020 at 11:19

Ganesh Sanap - MVP · Accepted Answer · 2020-03-04 10:54:12Z

0

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".

answered Mar 4, 2020 at 10:54

45.7k22 gold badges31 silver badges61 bronze badges

1

It works perfectly! thank you so much!
– Simona M
Commented Mar 4, 2020 at 11:17
Hi @Simona, Please Upvote(^) and accept as an Answer as it helped you. so that it will help others in future to find the correct answer easily.
– Ganesh Sanap - MVP
Commented Mar 23, 2020 at 9:21

Add a comment |

1 Answer 1