if then... do this query.
In the below - column Principal Check I have put:
=if([Principal survey drawing required?]2="Yes",[Principal drawing validated?]="Awaiting response","Not Required")
I am wanting the Principal drawing validated? column to have an entry, "Awaiting response" based on Yes in column 'Principal survey drawing required?' column. I am using the Principal check column as the check column.
I am getting unparseable. I am not sure this is the best way as will the default data allow the user to type over with the answer yes once complete in column Principal drawing validated? Thanks in advance.