MS Lists Calculated Column Error

Question

**Error:**Sorry, something went wrong

The formula contains a syntax error or is not supported.

Transgression Action Type Calculate Column:

=IF(AND([Nr Transgression]="1.1.1

",[Nr of Occurrence]= "1"),"D",

IF(AND([Nr Transgression]="1.1.1

",[Nr of Occurrence]= "2"),"D",

IF(AND([Nr Transgression]="1.1.1

",[Nr of Occurrence]= "3"),"D",

IF(AND([Nr Transgression]="2.1.1

",[Nr of Occurrence]= "1"),"VW",

IF(AND([Nr Transgression]="2.1.1

",[Nr of Occurrence]= "2"),"WW",

IF(AND([Nr Transgression]="2.1.1

",[Nr of Occurrence]= "3"),"FWW",

IF(AND([Nr Transgression]="2.2.1

",[Nr of Occurrence]= "1"),"FWW/D",

IF(AND([Nr Transgression]="2.2.1

",[Nr of Occurrence]= "2"),"D",

IF(AND([Nr Transgression]="2.2.1

",[Nr of Occurrence]= "3"),"D",

IF(AND([Nr Transgression]="2.3.1

",[Nr of Occurrence]= "1"),"WW",

IF(AND([Nr Transgression]="2.3.1

",[Nr of Occurrence]= "2"),"FWW",

IF(AND([Nr Transgression]="2.3.1

",[Nr of Occurrence]= "3"),"D",

IF(AND([Nr Transgression]="2.3.2

",[Nr of Occurrence]= "1"),"Formal discussion/VW",

IF(AND([Nr Transgression]="2.3.2

",[Nr of Occurrence]= "2"),"VW/WW",

IF(AND([Nr Transgression]="2.3.2

",[Nr of Occurrence]= "3"),"WW/FWW",

IF(AND([Nr Transgression]="2.3.3

",[Nr of Occurrence]= "1"),"WW/FWW/D",

IF(AND([Nr Transgression]="2.3.3

",[Nr of Occurrence]= "2"),"FWW/D",

IF(AND([Nr Transgression]="2.3.3

",[Nr of Occurrence]= "3"),"D",

IF(AND([Nr Transgression]="2.3.4

,[Nr of Occurrence]= "1"),"VW",

IF(AND([Nr Transgression]="2.3.4

",[Nr of Occurrence]= "2"),"WW",

IF(AND([Nr Transgression]="2.3.4

",[Nr of Occurrence]= "3"),"FWW",

IF(AND([Nr Transgression]="2.3.5

",[Nr of Occurrence]= "1"),"VW",

IF(AND([Nr Transgression]="2.3.5

",[Nr of Occurrence]= "2"),"WW",

IF(AND([Nr Transgression]="2.3.5

",[Nr of Occurrence]= "3"),"FWW",

IF(AND([Nr Transgression]="2.3.6

",[Nr of Occurrence]= "1"),"WW/FWW/D",

IF(AND([Nr Transgression]="2.3.6

",[Nr of Occurrence]= "2"),"FWW/D",

IF(AND([Nr Transgression]="2.3.6

",[Nr of Occurrence]= "3"),"D",

IF(AND([Nr Transgression]="2.3.7

",[Nr of Occurrence]= "1"),"WW/FWW/D",

IF(AND([Nr Transgression]="2.3.7

",[Nr of Occurrence]= "2"),"FWW/D",

IF(AND([Nr Transgression]="2.3.7

",[Nr of Occurrence]= "3"),"D",

IF(AND([Nr Transgression]="2.3.8

",[Nr of Occurrence]= "1"),"VW/WW",

IF(AND([Nr Transgression]="2.3.8

",[Nr of Occurrence]= "2"),"WW/FWW",

IF(AND([Nr Transgression]="2.3.8

",[Nr of Occurrence]= "3"),"D/FWW",

IF(AND([Nr Transgression]="2.3.9

",[Nr of Occurrence]= "1"),"WW/FWW/D",

IF(AND([Nr Transgression]="2.3.9

",[Nr of Occurrence]= "2"),"FWW/D",

IF(AND([Nr Transgression]="2.3.9

",[Nr of Occurrence]= "3"),"D",

IF(AND([Nr Transgression]="2.3.10

",[Nr of Occurrence]= "1"),"WW/FWW/D",

IF(AND([Nr Transgression]="2.3.10

",[Nr of Occurrence]= "2"),"FWW/D",

IF(AND([Nr Transgression]="2.3.10

",[Nr of Occurrence]= "3"),"D",

IF(AND([Nr Transgression]="2.4.1

",[Nr of Occurrence]= "1"),"WW/FWW/D",

IF(AND([Nr Transgression]="2.4.1

",[Nr of Occurrence]= "2"),"FWW/D",

IF(AND([Nr Transgression]="2.4.1

",[Nr of Occurrence]= "3"),"D",

IF(AND([Nr Transgression]="2.4.2

",[Nr of Occurrence]= "1"),"WW/FWW/D",

IF(AND([Nr Transgression]="2.4.2

",[Nr of Occurrence]= "2"),"FWW/D",

IF(AND([Nr Transgression]="2.4.2

",[Nr of Occurrence]= "3"),"D",

IF(AND([Nr Transgression]="2.4.3

",[Nr of Occurrence]= "1"),"WW/FWW/D",

IF(AND([Nr Transgression]="2.4.3

",[Nr of Occurrence]= "2"),"FWW/D",

IF(AND([Nr Transgression]="2.4.3

",[Nr of Occurrence]= "3"),"D",

IF(AND([Nr Transgression]="2.4.4

",[Nr of Occurrence]= "1"),"WW/FWW/D",

IF(AND([Nr Transgression]="2.4.4

",[Nr of Occurrence]= "2"),"FWW/D",

IF(AND([Nr Transgression]="2.4.4

",[Nr of Occurrence]= "3"),"D",

IF(AND([Nr Transgression]="3.1.1

",[Nr of Occurrence]= "1"),"VW/WW",

IF(AND([Nr Transgression]="3.1.1

",[Nr of Occurrence]= "2"),"WW/FWW",

IF(AND([Nr Transgression]="3.1.1

",[Nr of Occurrence]= "3"),"FWW/D",

IF(AND([Nr Transgression]="3.2.1

",[Nr of Occurrence]= "1"),"VW/WW",

IF(AND([Nr Transgression]="3.2.1

",[Nr of Occurrence]= "2"),"WW/FWW",

IF(AND([Nr Transgression]="3.2.1

",[Nr of Occurrence]= "3"),"FWW/D",

IF(AND([Nr Transgression]="3.3.1

",[Nr of Occurrence]= "1"),"VW/WW",

IF(AND([Nr Transgression]="3.3.1

",[Nr of Occurrence]= "2"),"WW/FWW",

IF(AND([Nr Transgression]="3.3.1

",[Nr of Occurrence]= "3"),"FWW/D",

IF(AND([Nr Transgression]="3.4.1

",[Nr of Occurrence]= "1"),"VW/WW",

IF(AND([Nr Transgression]="3.4.1

",[Nr of Occurrence]= "2"),"WW/FWW",

IF(AND([Nr Transgression]="3.4.1

",[Nr of Occurrence]= "3"),"FWW/D",

IF(AND([Nr Transgression]="3.5.1

",[Nr of Occurrence]= "1"),"WW/FWW/D",

IF(AND([Nr Transgression]="3.5.1

",[Nr of Occurrence]= "2"),"FWW/D",

IF(AND([Nr Transgression]="3.5.1

",[Nr of Occurrence]= "3"),"D",

IF(AND([Nr Transgression]="3.6.1

",[Nr of Occurrence]= "1"),"VW/WW",

IF(AND([Nr Transgression]="3.6.1

",[Nr of Occurrence]= "2"),"WW/FWW",

IF(AND([Nr Transgression]="3.6.1

",[Nr of Occurrence]= "3"),"FWW/D",

IF(AND([Nr Transgression]="3.7.1

",[Nr of Occurrence]= "1"),"FWW/D",

IF(AND([Nr Transgression]="3.7.1

",[Nr of Occurrence]= "2"),"D",

IF(AND([Nr Transgression]="3.7.1

",[Nr of Occurrence]= "3"),"D",

IF(AND([Nr Transgression]="4.1.1

",[Nr of Occurrence]= "1"),"FWW",

IF(AND([Nr Transgression]="4.1.1

",[Nr of Occurrence]= "2"),"D",

IF(AND([Nr Transgression]="4.1.1

",[Nr of Occurrence]= "3"),"D",

IF(AND([Nr Transgression]="4.2.1

",[Nr of Occurrence]= "1"),"FWW",

IF(AND([Nr Transgression]="4.2.1

",[Nr of Occurrence]= "2"),"D",

IF(AND([Nr Transgression]="4.2.1

",[Nr of Occurrence]= "3"),"D",

IF(AND([Nr Transgression]="4.3.1

",[Nr of Occurrence]= "1"),"WW/FWW/D",

IF(AND([Nr Transgression]="4.3.1

",[Nr of Occurrence]= "2"),"FWW/D",

IF(AND([Nr Transgression]="4.3.1

",[Nr of Occurrence]= "3"),"D",

IF(AND([Nr Transgression]="4.4.1

",[Nr of Occurrence]= "1"),"FWW/D",

IF(AND([Nr Transgression]="4.4.1

",[Nr of Occurrence]= "2"),"D",

IF(AND([Nr Transgression]="4.4.1

",[Nr of Occurrence]= "3"),"D",

IF(AND([Nr Transgression]="4.5.1

",[Nr of Occurrence]= "1"),"FWW/D",

IF(AND([Nr Transgression]="4.5.1

",[Nr of Occurrence]= "2"),"D",

IF(AND([Nr Transgression]="4.5.1

",[Nr of Occurrence]= "3"),"D",

"D")))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

Answer 1

Dear respected  Roald Wagener,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

I’m sorry you’re having a problem but based on your description we can work together to resolve it.

For the situation you encountered, we deeply understand the inconvenience caused and apologize for it.

As per your description, firstly could you please upload a screenshot of your SharePoint list view with columns for our reference, so we can understand your exact scenario and provide our suggestion in a productive manner, perhaps some related screenshots will be helpful.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad