Running SP19 On Prem. Have a list with a column looking at type category with three options, and a completed column. I am looking at a calculated field/column in the list to filter a view with.
- 1st condition- Type A and yes
- 2nd condition Type B and Yes
- 3rd condition- Type C and complete doesn't matter.
What I have so far is:
=IF(AND([Validation Type]="Technical and Business Validation,[Technical Validation Complete]="Yes","Yes",IF([Validation Type]="Business Validation Only","Yes",IF([Validation Type]="Technical Validation Only","No")))
The filters seem to work with condition 2 and 3; but, when I add in the first statement, syntax errors. Have been trying to work this out several different ways and no success.
All help is appreciated.