I have a column "C" which must be completed if column "A" and "B" both equal yes. I have put a validation on column "C"
ColumnA!="To be confirmed"&&ColumnB!="To be confirmed"
When I preview and try to save without filling in column "C" it prompts me to complete the column with a red box and message, the problem occurs when I type in column "C", it wont let me save the form, just keeps telling me column "C" needs to be completed??
Choice options for column A and B are "To be confirmed" and "Yes"
Column C is free text