The scenario I have written supposed to work like below...
A has 4 multiple choice options, (Completed, Suspended, Blocked, Cancelled)
B has 4 multiple choice options (Completed, Suspended, Blocked, Cancelled)
The same for C and D.
If A is completed then only B can be chosen (any value) and if the user selects B as completed, then C can be selected (any value) and other columns will not be able to be chosen. I have spent many scenarios but none of them seem to be work, some function such as only if all are completed, you can submit it. I would appreciate, if someone corrects my expression I have written below. Thanks beforehand.
=IF( AND( OR( (AND([B]<>"";[A]="completed")); (OR( (AND([B]="completed";[C]<>"")); (AND([B]<>"";[C]<>"")); ) ); ); ); TRUE;FALSE)