2

I need column1 to determine the value of column2.

So If column1 equals yes column2 needs to equal yes;

and

If column1 equals no then column2 should equal no

1 Answer 1

5

You can do it as

=Column1

Since you said if column1 = yes the column2 = yes

If you are looking for more logic.. then the conditional logic goes as

=if(column1="Yes", "Yes", "No")
1

Your Answer

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

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