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
Solved! Go to Solution.
Here's how I would do it.