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
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this communityYou 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")