Mandatory Check based on multiple conditions

[Chauche]

Hi There,

I am working on creating a new column which check mandatory attributes based on the "Nature Field" (more details in the attached). All the "Yes" require values as per the Nature and are mandatory. If it finds the required value based on the conditions then update "OK" else "NO"

The attached sheet first part has all the conditions and I have given a result below.

The difficulty arise with the col "Nature of Confidentiality" dependency on the col "Confidentiality".

Since it's more complex describing in words I have attached sheet with complete details. Hope it will be helpful and understandable.

Regards,

Chetan

[mattnason1]

Here's how I would do it.

[mattnason1 · Accepted solution]

Just realized I read the nature of confidentiality part wrong.  Formula should be:

If [Confidentiality] IN ('T2', 'T3') then [Nature of Confidentiality]
else "OK" endif

Update attached.