I have made a list with InfoPath in SharePoint. All the questions are either "accepted" or "notaccepted" (radiobuttons) and I want to make a new column (in SharePoint). If someone choose "accepted", the value it gives to the list is 1, and "Notaccepted" is 2.
I want to create a new column which looks at all the columns in the list (let's say for easy sake A, B & C) and when they are all at value 1, the new column gets the value accepted, and when only 1 question is answered with "Notaccepted" ( so only one,or more, value 2) it has to say "Notaccepted".
A=1 B=1 C= 1
It should return "Accepted",
When it is
A=1 B=2 C=1
it should give "Notaccepted"
A=2 B=2 C=1
it should still say "Not accepted"
Can anyone help me out with this formula?