Skip to main content
SharePoint

Return to Question

Became Hot Network Question
Tweeted twitter.com/StackSharePoint/status/1234811005965869056
spell correction
Source Link
Gaurravs
Gaurravs
  • 3.6k
  • 12
  • 23
  • 33

Say, I have a sharepointlistSharePoint list with 2 columns, A and B. A contains a list with three items: choice 1, choice 2 and choice 3. B is a yes/no (true/false) field.

I would like to formulate an condition that does this: If A = 2, then set B to yes.

I am new to the formulas, hence the question. I tried some things like: =If([A]="2","true", "false")=If([A]="2","true", "false") Did not work.

Say, I have a sharepointlist with 2 columns, A and B. A contains a list with three items: choice 1, choice 2 and choice 3. B is a yes/no (true/false) field.

I would like to formulate an condition that does this: If A = 2, then set B to yes.

I am new to the formulas, hence the question. I tried some things like: =If([A]="2","true", "false") Did not work.

Say, I have a SharePoint list with 2 columns, A and B. A contains a list with three items: choice 1, choice 2 and choice 3. B is a yes/no (true/false) field.

I would like to formulate an condition that does this: If A = 2, then set B to yes.

I am new to the formulas, hence the question. I tried some things like: =If([A]="2","true", "false") Did not work.

Source Link
Mirte
Mirte
  • 143
  • 1
  • 2
  • 14

If A = 2, then set B to yes

Say, I have a sharepointlist with 2 columns, A and B. A contains a list with three items: choice 1, choice 2 and choice 3. B is a yes/no (true/false) field.

I would like to formulate an condition that does this: If A = 2, then set B to yes.

I am new to the formulas, hence the question. I tried some things like: =If([A]="2","true", "false") Did not work.